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

Senior Sql Database Administrator

Senior Database Administrator (MS SQL & AWS RDS) (Remote)