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.
#LI-MM1
#LI-Onsite