MS SQL, Database Administrator- Washington DC

Company:

Cogent Communications is a global, Tier 1 facilities-based ISP, consistently ranked as one of the top five networks in the world and is publicly traded on the NASDAQ Stock Market under the ticker symbol CCOI. Cogent specializes in providing businesses with high speed Internet access and Ethernet transport services. Cogent's facilities-based, all-optical IP network backbone provides IP services globally. Since its inception, Cogent has unleashed the benefits of IP technology, building one of the largest and highest capacity IP networks in the world. This network enables Cogent to offer large bandwidth connections at highly competitive prices. Cogent also offers superior customer support by virtue of its end-to-end control of service delivery and network monitoring. A competitive base salary and a full benefits package including; Health, Dental, Vision, Paid Time Off ( PTO), Short- and Long-Term Disability, Life Insurance, Holidays, Parental Leave, 401 ( k) plan with employer match, stock options, and an Employee Assistance Program. Most benefits take effect within 30 days of employment, and some require a waiting period.

Job Summary:

The SQL Server DBA will be responsible for the implementation, configuration, maintenance, performance and support of critical SQL Server DB systems, to ensure the availability and consistent performance of our corporate and business applications. This is a “hands-on” position requiring solid technical skills, as well as excellent interpersonal and communication skills.

The successful candidate will be responsible for the development and support of different versions of SQL server and other database technologies like MySQL, Oracle, etc., ensuring their optimal functioning ( security, health, performance, etc.).

The successful candidate must be capable of working independently or collaboratively with other team members.

Essential Duties and Responsibilities:

• Manage SQL Server databases and other RDBMS through different product lifecycle from development to mission-critical production systems
• Install, Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security
• Support 24x7 operational database support including periodic on-call rotation
• Conduct diagnostic tests and evaluate performance metrics on the databases
• Monitor the databases to ensure system health, functionality and remediate problems/issues in a timely manner
• Migrate/convert databases from Oracle 11g, 12c and 19c to MS SQL server
• Execute & maintain SQL scripts and utility jobs for MS SQL database maintenance
• Implement & manage MS SQL database backups and restore, clustering, always on, failover and load balancing technologies
• Perform DB refreshes from Prod to lower environments
• Monitor database status, logs, space utilization, extents, locks, blockings and deadlocks and clearing them accordingly
• Implement and support MS SQL ( Active/Passive & Active/Active), Multi Node Clustering for four node clusters
• Apply data modeling techniques to ensure that development and implementation support efforts meet integration and performance expectations
• Independently analyze, solve, and correct issues in real time, providing end-to-end problem resolution
• Refine and automate regular processes, track issues, and document changes
• Assist developers and application owners with complex query tuning and optimization
• Perform scheduled maintenance and support release deployment activities after hours
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members
• Perform all other DB related tasks and activities as assigned
  

Qualifications:

• 3+ years of experience supporting MS SQL Server Databases
• Experience with Performance Tuning and Optimization ( PTO), using native monitoring and troubleshooting tools
• Experience with backups, restores and recovery models
• Knowledge of High Availability ( HA) and Disaster Recovery ( DR) options for SQL Server
• Experience working with Windows server, including Active Directory
• Experience creating and deploying SSRS, SSIS and SSAS packages
• Ability to organize and plan work independently
• Ability to multi-task and context-switch effectively between different activities and teams
• Experience with MySQL, Oracle and MariaDB running on Linux
• Experience with VMware, NetApp and SSRS a plus
• Ability to write, keep and maintain SOP, documentation, etc
  
  

Other qualification that would be nice to have include:

• Oracle DB knowledge in a Unix environment
• Knowledge with Rubrik MS SQL backup technology
• Knowledge with SQL Monitor MS SQL performance monitoring tool
• Knowledge with Power Script/DBATools
• Excellent written and verbal communication
• Flexible, team player, “get-it-done” personality
  
  

Physical Requirements:

• Remains in a sitting/stationary position continually or almost continually during the work day
• Operates a computer and performs desk-based computer tasks continually; frequently viewing a computer screen
• Prefer the ability to lift, carry, push, pull objects and/or equipment that weighs up to 50 pounds on rare occasions
  
  

COVID-19 Policy:

Cogent has adopted a mandatory vaccination and booster policy which requires all U.S. employees to be fully vaccinated with one booster against COVID-19. Prior to beginning employment, new employees must provide proof of vaccination or apply for and receive an accommodation to be exempt from the policy.

By submitting an application or resume for this position, I understand that is an in-office position and agree to abide Cogent’s mandatory vaccination policy.

To apply for the MS SQL, Database Administrator position, please submit your resume and cover letter to careers@cogentco.com .

Cogent Communications is an Equal Opportunity Employer.