Job Description
Job Title: Enterprise Database Specialist
The role of an Enterprise Database Specialist is to design, implement, and maintain complex database systems for our organization. This includes overseeing the development and deployment of database solutions, ensuring data security and integrity, and optimizing database performance.
Responsibilities:
• Administer, configure, and maintain Microsoft SQL Server (on-premises) and AWS RDS/Redshift environments.
• Perform regular maintenance tasks such as backups, restores, patching, and capacity planning.
• Manage database security, user access, and roles across environments.
• Provision, configure, and manage AWS RDS (SQL Server, PostgreSQL) and Redshift instances.
• Implement backup strategies, monitoring, and disaster recovery solutions in the cloud.
Requirements:
• Experience as a database administrator with a strong foundation in SQL Server administration, backup/restore strategies, and high availability solutions.
• Hands-on experience managing AWS RDS (SQL Server/PostgreSQL) and Amazon Redshift, including provisioning, scaling, backups, snapshots, and security configurations.
• Proficiency with monitoring tools like AWS CloudWatch, SolarWinds, and Redgate SQL Monitor, with the ability to configure alerts, identify trends, and proactively address performance bottlenecks.
• Expertise in performance tuning for SQL Server, RDS, and Redshift.
• Strong understanding of database security best practices, user access controls, encryption, and auditing.
• Ability to create and maintain detailed runbooks, SOPs, and knowledge base articles for repeatable processes and troubleshooting procedures.
Bonus Points:
• Familiarity with automation and scripting using PowerShell, Python, or Bash to streamline database tasks and monitoring.
• Hands-on experience with CI/CD pipelines to support database changes and deployments using tools like AWS CodePipeline or GitLab CI.
