Position Overview:
The Senior SQL Server database administrator position is responsible for providing all-encompassing SQL Server database support. This role requires a high sense of ownership of the assigned tasks, end-to-end problem resolution, and proactive approach
.
Responsibilities include but are not limited t
- o:
Manage all SQL Server database lifecycle environments, including mission-critical syste - ms.Identify and resolve SQL Server issues in real time, providing end-to-end problem resoluti
- on.Perform standard SQL Server and Oracle database administration tasks, such as database monitoring, installation, configuration and patching, backups and recovery, high availability configuration, database refresh, data replication, code reviews, and SQL tuni
- ng.Perform scheduled maintenance and support release deployment activities outside of regular business hou
- rs.Resolve performance issues, perform complex query tuning, and schema refinement ta
- sksManage platform and database security, including implementation and enforcement of the SQL Server security best practices and Information Security standards including but not limited to user roles and groups, access methods, and integration with external security too
- ls.Provide on-call support for assigned ar
- easEffectively support application development teams ne
- edsPrepare, review, and execute DML/DDL scripts as part of the release management proc
- essSupport and manage Azure SQL Databa
- se.Support CDC/data replication using Qlik Replicate and ETL processes using S
- SISPerform all database administration and support related tasks that ensure the highest standards of database availability, resilience, integrity, security, and performan
- ce.Display a high level of effort and commitment toward completing goals in a timely manner. Able to start and finish projects on his or her own. Able to react quickly when troubleshooti
- ng.Demonstrate excellent analytical skills and attention to deta
- il.Provide technical leadership to the SQL Server DBA team, ensuring high standards of architecture, design, and implementati
- on.Oversee the work of junior SQL Server DBAs, offering guidance, code reviews, and constructive feedback to maintain quality and consisten
- cy.Support the professional development of junior team members through coaching, skill-building opportunities, and regular feedba
- ck.Drive knowledge transfer within the team through documentation, mentoring, and collaborative problem-solvi
- ng.Adapt to new challenges and responsibilities, acquiring necessary competencies on the job to support team and organizational goa
- ls.Demonstrate a proactive commitment to continuously learning and applying new skills, tools, and technologies as required by evolving business and technical nee
- ds.Adapt to new challenges and responsibilities, acquiring necessary competencies on the job to support team and organizational goa
- ls.Participate in Oracle 24x7 on-call rotation after 3 mont
- hs.Learn and support MongoDB and QLIK replication within 6 mont
hs.
Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any t
ime.
Required Qualifications/Skills/Capabili
- ties:Undergraduate degree in Bachelor of Engine
- ering8+ years of SQL Server database administration experience in a similar work environment and
- roleAdvanced knowledge of SQL Server internals, backups and restores, recovery models, clustering, database mirroring/replication and Always On Availability Gr
- oups.Experience working with Oracle Database for a minimum 3-4 y
- ears.Advanced knowledge of SQL Server security architecture and industry best prac
- ticesAdvanced knowledge of database performance tuning using monitoring and troubleshooting
- toolsAdvanced knowledge and experience with generating data definition language from the data m
- odelsAdvanced knowledge of T-SQL and PowerShell scri
- ptingAdvanced level of knowledge using SQL Server Integration Services (
- SSIS)Experience with virtualization (VM
- Ware)Experience with Azure SQL Dat
- abaseExperience with release management processes with database
- codeFamiliarity with Change Data Capture (CDC). Attunity or Qlik Replicate knowledge would be a
- plus.Must be capable of 100% ownership and responsibility for the assigned
- tasksPossess excellent communication, problem solving, planning, and customer service s
- killsExercise self-control under trying or tough circumstances, situations, or under any kind of pre
- ssureContinually strive to gather latest technical knowledge and inform
- ationBe capable of actively exchanging ideas with others and build on their ideas to identify new solu
- tionsBe capable of working both independently or collaboratively and maintain a positive attitude in the work
- placeAvailability for after-hours and weekend work (as nee
- ded).Able to work under pressure and communicate effecti
vely.
