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 to:
- Manage all SQL Server database lifecycle environments, including mission-critical systems.
- Identify and resolve SQL Server issues in real time, providing end-to-end problem resolution.
- 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 tuning.
- Perform scheduled maintenance and support release deployment activities outside of regular business hours.
- Resolve performance issues, perform complex query tuning, and schema refinement tasks
- Manage 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 tools.
- Provide on-call support for assigned areas
- Effectively support application development teams needs
- Prepare, review, and execute DML/DDL scripts as part of the release management process
- Support and manage Azure SQL Database.
- Support CDC/data replication using Qlik Replicate and ETL processes using SSIS
- Perform all database administration and support related tasks that ensure the highest standards of database availability, resilience, integrity, security, and performance.
- 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 troubleshooting.
- Demonstrate excellent analytical skills and attention to detail.
- Provide technical leadership to the SQL Server DBA team, ensuring high standards of architecture, design, and implementation.
- Oversee the work of junior SQL Server DBAs, offering guidance, code reviews, and constructive feedback to maintain quality and consistency.
- Support the professional development of junior team members through coaching, skill-building opportunities, and regular feedback.
- Drive knowledge transfer within the team through documentation, mentoring, and collaborative problem-solving.
- Adapt to new challenges and responsibilities, acquiring necessary competencies on the job to support team and organizational goals.
- Demonstrate a proactive commitment to continuously learning and applying new skills, tools, and technologies as required by evolving business and technical needs.
- Adapt to new challenges and responsibilities, acquiring necessary competencies on the job to support team and organizational goals.
- Participate in Oracle 24x7 on-call rotation after 3 months.
- Learn and support MongoDB and QLIK replication within 6 months.
Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time.
Required Qualifications/Skills/Capabilities:
- Undergraduate degree in Bachelor of Engineering
- 8+ years of SQL Server database administration experience in a similar work environment and role
- Advanced knowledge of SQL Server internals, backups and restores, recovery models, clustering, database mirroring/replication and Always On Availability Groups.
- Experience working with Oracle Database for a minimum 3-4 years.
- Advanced knowledge of SQL Server security architecture and industry best practices
- Advanced knowledge of database performance tuning using monitoring and troubleshooting tools
- Advanced knowledge and experience with generating data definition language from the data models
- Advanced knowledge of T-SQL and PowerShell scripting
- Advanced level of knowledge using SQL Server Integration Services (SSIS)
- Experience with virtualization (VMWare)
- Experience with Azure SQL Database
- Experience with release management processes with database code
- Familiarity 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 tasks
- Possess excellent communication, problem solving, planning, and customer service skills
- Exercise self-control under trying or tough circumstances, situations, or under any kind of pressure
- Continually strive to gather latest technical knowledge and information
- Be capable of actively exchanging ideas with others and build on their ideas to identify new solutions
- Be capable of working both independently or collaboratively and maintain a positive attitude in the workplace
- Availability for after-hours and weekend work (as needed).
- Able to work under pressure and communicate effectively.
