About the job
Title: Senior PostgreSQL / AWS Database Administrator (PostgreSQL, AWS, Oracle)
Location: Washington D.C. (hybrid – 2 days a week onsite)
Salary: $140K – $150K + Excellent Benefits!
3rd Party C2C/Visa Transfer: No
Referral Fee: $1000 – Refer qualified colleague, friends, or family.
Must Haves
PostgreSQL
AWS Aurora Global
AWS CI/CD Pipeline
DMS – Data Migration
Oracle 19C – winding down – must be proficient
AWS EC2
Nice to haves:
AWS Dynamo DB
AWS S3
AWS Backup and Recovery
AWS Cloudwatch
We are looking for a committed and driven Senior Database Administrator with a broad understanding and appreciation of AWS Cloud Databases and hands-on experience with AWS database components and CI/CD pipelines.
We expect our team members to demonstrate technical proficiency as well as strong communication and collaboration abilities. The Senior Database Administrator will contribute directly to design and operational processes and will be empowered to proactively drive best practices and changes at the program and organizational level. Candidates should demonstrate knowledge and understanding of Postgres, Oracle and AWS Cloud databases technologies, frameworks, and concepts along with excellent communications skills and a desire to learn and grow.
The Database Administration Team is responsible for securing database systems by supporting existing controls and processes and through leading efforts to continually improve security across multiple dimensions and domains and enterprise systems. The Senior Database Administrator will support operational database management processes. We expect the Senior DBA to work effectively with internal stakeholders, including the information security team, leadership, developers, system operations and network administrators, and with external vendors including Cloud Service Providers and databases vendors.
The Senor DBA will also be responsible for performance monitoring and tuning. They will work collaboratively with developers, IT Infrastructure and IT Operations to ensure the system is operating within desired specification ranges.
Expertise in enterprise databases management, including Postgres, Oracle and AWS Cloud platform, Identity and Access Management (IAM), Cloud Watch, Performance Insights and PostgreSQL queries management is desirable. We welcome candidates with strong Cloud or application deployment backgrounds with a willingness to develop expertise in additional database engineering specialties.
Essential Duties and Responsibilities:
Operational Oversight and Support:
Serve as a key escalation point within the database administration team, providing guidance for effective resolution.
Directly triage and respond to databases alerts, database capacity and performance reports, and end-user requests on a regular basis.
Identify and resolve issues in database related controls, systems, and applications.
Lead and support maintenance and troubleshooting activities for the Database Administration program.
Lead and support database vulnerability management processes, such as database patching, database security scanning vulnerability assessment, prevention and remediation efforts.
Architectural Excellence and Resilience:
Leading and working with team members to configure database resources including but not limited on the Postgres, Oracle and AWS Aurora PostgreSQL RDS and DynamoDB and continuously monitor and proactively to prevent and correct any issues to ensure the highest availability for databases systems.
Design and implement robust security measures on all databases applications including web applications, cloud infrastructure, and enterprise systems.
Using AWS CI/CD pipeline with Python and AWS CLI for databases resources management and deployment to ensure predictability and consistencies on all databases systems.
Implement consistent AWS Aurora RDS Parameter groups for both cluster and instance levels.
Identify and implement the best practices to secure database resources and web applications against potential threats.
Ensure compliance with relevant regulations, standards, organizational policies, and best practices, including cloud standards and best practices.
Databases systems availabilities and reliabilities:
Monitor database status activity daily to make sure that database is up running and is working properly
Support database server Linux patching activities on database server monthly to keep server secured and minimize the risk of malicious impact
Manage and Maintain and Apply Oracle Critical Patch Updates (CPU) patches each quarter and other oracle recommended patch sets when they become available and upgrade AWS Aurora PostgreSQL databases to ensure proper security measures and address any known security risks
Configure and validate Oracle and AWS database backup, exports and snapshots every day to make sure they are working properly
Maintain and update SOPs for Database disaster recovery. Perform periodic review and testing for database recovery processes.
Follow DBA Protocol and procedures to promptly address any database system issues. Ensure adapts to the changing database security landscape, making informed recommendations and decisions to database systems configurations, security controls.
Automate controls and processes where possible.
APPLY