Database Administrator - REMOTE

Database Administrator - Permanent - Remote

Proclinical Staffing is seeking a Database Administrator to join an innovative medical care organization. This is a permanent role with the opportunity to work remotely.

Primary Responsibilities

This individual will be reporting into the Senior Director of Database Administration. As the Database Administrator, you will be responsible for the administration of our PostgreSQL, MySQL and MS SQL Server database environments.

Skills & Requirements:

• Bachelor's degree in Computer Science, Information Technology, or a related field. Minimum 8 years proven experience in a Database Administrator or similar role.
• Advanced knowledge of PostgreSQL and MySQL databases and their administration, database design, implementation, performance tuning, and capacity planning.
• Knowledge of Microsoft SQL Server databases and their administration, including replication
• Solid experience in shell scripting, Coding Scripts, Procedures, functions, etc.
• Excellent in OLTP Performance tuning
• Strong analytical, communication, and troubleshooting skills. Excellent in solving complex technical and business problems.
• Ability to work under pressure and adhere to deadlines/SLA agreements (On-time delivery, customer service, and quality of execution are key performance requirements)
• Skills required in areas of Microsoft SQL Server 2019+ such as replication, SQL Agent jobs
• Highly motivated - self-starter, proactive with time management skills
• Excellent problem-solving and troubleshooting skills.
• Strong communication and collaboration skills.
• Relevant certifications (e.g., MySQL and/or PostgreSQL DBA, AWS Certifications) are a plus
• Knowledge of Snowflake databases and their administration
• Experience using PostgreSQL and MySQL in an Amazon Web Services environment (RDS/Aurora)

The Database Administrator will:

• Monitor and optimize database performance and capacity planning.
• Performance tuning of MySQL, PostgreSQL, and MS SQL Server databases
• Develop methods for monitoring, proactively monitoring database performance and come up with suggestions
• Troubleshoot database issues, maintain database systems availability and scalability
• Work as part of a team to provide 7x24 support as needed (will be on pager rotation)
• Standardize the program environments to ensure that we have the same set of procedures and guidelines for developing queries and moving releases to production.
• Participate in the application deployment and roll back process
• Investigate all User feedback/production issues in a timely manner and provide a recommendation to the development team.
• Assess weaknesses of our current environment, recommend improvements to our database environments to help standardize and streamline the move to prod and support process
• Implement and maintain database security
• Preventive maintenance
• Setup and maintain documentation and standards
• Do general technical troubleshooting and give consultation to development teams
• Help design and develop tools for Database Services team
• Perform Load testing.
• Design and Deploy the database for the specific requirements, perform data migration
• Lead Components of Projects/tasks
• Identify Bottlenecks and provide solutions
• Support Linux and Windows DB Servers, in production and other environments.
• Will act as a project resource - research, testing, implementation, training etc.

If you are having difficulty in applying or if you have any questions, please contact Patrick Mooney at p.mooney@proclinical.com.

Proclinical is a specialist employment agency and recruitment business, providing job opportunities within major pharmaceutical, biopharmaceutical, biotechnology and medical device companies.

Proclinical Staffing is an equal opportunity employer.