Summary

The Senior Database Administrator will be responsible for building and maintaining database systems and ensuring data security in our firm. Your role will also entail troubleshooting issues in our database management software and providing quick resolution

Essential Duties and Responsibilities

• Database Administration
  1. Install, configure, upgrade and maintain SQL Servers, databases, and related components
  2. Implement and manage database security, user permissions, roles and access controls
  3. Perform database backups and restores to ensure data integrity and availability
  4. Monitor database performance, optimize queries and tune the server for optimal performance
  5. Implement and manage high availability and disaster recovery solutions like clustering, mirroring, log shipping etc.
  6. Automate routine tasks like backups, index maintenance etc. using scripts and SQL Server Agent jobs
  7. Develop and implement roadmaps in collaboration with data and application teams to migrate on-premise SQL Server solutions to equivalent or better cloud-native services
  8. Develop database server version control policies and implement them
• Database Development
  1. Work with application developers to design and implement new databases or modify existing ones
  2. Implement data modeling techniques and database normalization
  3. Review and implement DDL scripts from application development teams to ensure acceptable performance and data integrity
  4. Assist developers with complex queries, query tuning, and schema refinements
• Support and Maintenance
  1. Implement and maintain monitoring solutions to support critical databases and database processes, including routine maintenance jobs, backup jobs, testing backup viability via automated restores and validation
  2. Troubleshoot and resolve database issues in a timely manner
  3. Implement third-party application database update scripts
  4. Apply patches, updates, and implement security best practices
  5. Maintain documentation for database objects, processes, and procedures
  6. Provide training and knowledge transfer to other team members
  7. Proactively monitor SQL Server maintenance tasks, troubleshoot failed processes, and address issues as soon as possible
  8. Implement database backup and recovery methods, database access security and integrity, physical data storage design, and data storage administration in a way that meets business Recovery Point Objectives (RPO)

Education and Experience

• A bachelor's degree, preferably in computer science or a related discipline.
• At least 5 years of experience as an enterprise SQL Server DBA.
• Strong preference will be given to persons with Azure DBA certifications (e.g. Azure Database Administrator Associate)
• At least 2 years supporting Windows failover cluster-based Always-on HA architecture in production
• At least 5 years of experience developing and supporting reports and packages with SSRS and SSIS.
• At least one year of experience migrating SQL Server HA architecture to highly available serverless compute Azure native SQL database Service 
• At least one year of experience supporting highly available enterprise-scale Azure native SQL database services in production
• At least 3 years of experience supporting enterprise data warehouse environments 
• Exposure to PostgreSQL, Vertica DB and/or MongoDB (Atlas) is a strong plus
• Excellent analytical and problem-solving skills, with a keen eye for detail.

Physical Demands
 While performing the duties of this job, the employee is regularly required to type and look at a computer screen for long periods of the day. The employee must be able to sit for long periods of time.
 

Qualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed above are representative of the knowledge, skill, and/or ability required. Reasonable accommodations will be made to enable individuals with disabilities to perform the essential functions. 

Note

This job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice. 

Employee signature below constitutes employee's understanding of the responsibilities and the job qualifications of the position. 

Employee__________________________________ Date_____________ 

Automobile Protection Corporation (APCO) is a Drug Free Workplace as well as an Equal Opportunity Employer. Qualified applicants shall be considered for all positions without regard to race, color, sex, religion, national origin, age, disability, veteran status, or any other status protected by federal, state or local law.