Senior Sql Database Administrator

Job Summary:

PRIMARY FUNCTION:

The Senior SQL Database administrator (Sr. DBA) will be responsible for the design, implementation, maintenance, and optimization of SQL Servers and databases within the organization. This role involves ensuring the security, integrity, and performance of the databases while collaborating with various stakeholders to meet business requirements. The Sr. DBA will also work proactively to secure and patch the environment, highlight potential problems, and devise processes and procedures to prevent downtime.

SCOPE OF RESPONSIBILITY:

• Evaluate database requirements and recommend solutions to meet global business needs.

o Evaluation should include on-premises databases as well as cloud-based alternatives.

• Ensure database design meets performance, scalability, and availability requirements.
• Database Maintenance and Optimization: o Backups, restores, and integrity checks

o Monitor database performance

o Optimize queries and indexes for improved efficiency

o Troubleshoot and resolve database issues in a timely manner

• Security and Compliance:

o Implement and maintain database security policies

o Implement and maintain an annual database maintenance plan

o Ensure compliance with industry best practices

o Perform regular security audits and address any vulnerabilities or risks

• Disaster Recovery and High Availability

o Maintain our high availability cluster

o Ensure replication is operational

o Generate reports on database performance, usage, and capacity planning

• Provide technical guidance, assistance and mentorship to other DBA's and System Administrators

SPECIFIC DUTIES / ACCOUNTABILITIES:

• Expert-level knowledge of MS SQL Server
• Serve as an escalation point for resolving SQL issues either with performance or operation
• Support and monitor the enterprise SQL environment, resolve issues, and identify improvements
• Perform proactive system monitoring
• Develop and maintain system documentation
• Perform regular capacity planning and usage trending
• Perform regular system security reviews

BASIC QUALIFICIATIONS:

• Bachelor's degree in information systems, computer science, or related field, or equivalent experience and certifications
• At least 7 years of SQL experience in an enterprise environment
• Experience with Oracle databases
• Working knowledge of MS SQL in Azure
• Knowledge of IT security principles

ADDITIONAL QUALIFICATIONS:

• Advanced troubleshooting skills
• Experience automating tasks
• Experience with patch management products
• Experience with PeopleSoft
• Experience with AWS RDS a plus
• Must be able to handle a wide variety of work and work in a fast-paced environment.
• ITIL certification is preferred
• Windows / AWS / Azure certification desirable
• Ability to communicate effectively with customers, vendors, and employees.
• Ability to work with a globally dispersed team