Sr PostgreSQL DBA- 100 % Onsite role in MD

Unisoft Technology - Woodlawn, MD

Full-time - Senior

Woodlawn, MD

Professional, Scientific, and Technical Services

About the position

The Sr PostgreSQL DBA role is a critical position focused on managing and optimizing PostgreSQL databases within an AWS cloud environment. This position requires collaboration with application developers to design efficient database structures, implement robust backup and recovery plans, and ensure high availability and disaster recovery strategies. The role is 100% onsite in Maryland from day one, emphasizing the need for hands-on management of AWS resources related to PostgreSQL databases.

Responsibilities

• Collaborate with application developers to design and optimize database structures for efficient data storage and retrieval.
• Design and implement backup, recovery, and disaster recovery plans to protect critical data.
• Implement AWS cloud solutions that effectively utilize PostgreSQL databases.
• Manage AWS resources related to PostgreSQL databases, such as EC2 instances, RDS instances, and S3 storage.
• Implement database scaling and high availability strategies in the AWS cloud environment.
• Automate database tasks using AWS services like AWS Lambda, AWS CloudFormation, and AWS RDS/Aurora.
• Plan and execute database migration projects, including schema migration, data migration, and application migration.
• Develop and implement migration strategies to minimize downtime and ensure data consistency.
• Plan & perform database upgrades, applying patches, and ensuring compatibility with new versions of PostgreSQL and AWS services.
• Conduct thorough testing and validation of migrated databases to ensure data integrity and optimal performance.

Requirements

• Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).
• 12+ years of experience in Database Administration.
• Proven experience as a Database Administrator.
• In-depth knowledge of database management systems, primarily AWS PostgreSQL, SQL, and MongoDB.
• Familiarity with database design principles, data normalization, and indexing techniques.
• Understanding of data security and access control principles.
• Must have great experience in AWS RDS.
• Knowledge of cloud-based database services (e.g., AWS RDS, SCT, and DMS).
• Strong knowledge of PostgreSQL replication, high availability, and disaster recovery mechanisms in AWS Cloud environment.
• Experience with PostgreSQL monitoring and performance tuning tools.
• Proficiency in SQL and experience with writing complex queries and stored procedures.
• Strong analytical and problem-solving skills with an ability to troubleshoot database-related issues.
• Familiarity with Linux/Unix operating systems and shell scripting.

Nice-to-haves

• PostgreSQL (e.g., PostgreSQL Certified Professional).
• AWS certifications (e.g. AWS Certified Database - Specialty).