Sr. Postgres DBA - Hybrid - CC Pace Systems, Inc.
Washington, DC
About the Job
The Sr. Database Engineer will support operational database management processes. We expect the Sr. Database Engineer 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 Sr. Database Engineer 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.
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:
- Lead and work 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.
- Use 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 we adapt to the changing database security landscape, making informed recommendations and decisions to database systems configurations, security controls.
- Automate controls and processes where possible.
Compliance:
- Reach the goal of always being compliant. Collect and centrally maintain all database systems artifacts to respond to audits in a timely manner, with limited SME impact.
- Follow best practice to maintain and monitor classic Oracle database DBA privilege users
- Follow best practice to maintain and monitor the AWS cloud databases to ensure the secrets storing database user information are automatic rotated every 90 days.
- Follow best practice to grant proper permission when creating database users.
- Maintain classic Oracle database storage to ensure it is good stewards and saving cost by using proper storage type.
- Monitor the classic Oracle database space usage daily to make sure it has proper available space for the database to reduce space usage cost.
- Ensure all database related audits information is collected in a timely manner.
- Choose proper resource type and size when provisioning AWS RDS database related resources to reduce expenses.
Cloud Systems Design and Management:
- Design and implement AWS Cloud database systems to ensure failover and monitor capabilities are in place for the high availability of database resources.
- Design and support the DMS tasks of migrating Data from classic Oracle databases to Aurora Postgres clusters and s3 buckets
- Follow best practices to design and creation of database resources using CDK and ci/cd pipelines.
- Create, maintain, and implement Aurora Postgres Database clone from one environment to multiple environments.
- Continue implementing, improving, and securing database systems to enhance users’ management and monitoring of resources.
- Work with project teams to plan, architecture design, implementation, setting and enforce database standards on AWS Cloud systems environment including Aurora PostgreSQL, AWS DynamoDB and AWS Glue/Athena.
Requirements
- Qualified candidates will have 10+ years’ experience in enterprise database management, including Postgres, Oracle, and AWS Cloud platform, Identity and Access Management (IAM), Cloud Watch, Performance Insights, and PostgreSQL query management is desirable.
An Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against based on disability. EEO IS THE LAW CC Pace invites any applicant and/or employee to review the Company’s written Affirmative Action Plan. This plan is available for inspection upon request. If you are an individual with a disability and would like to request a reasonable accommodation as part of the employment selection process, please contact us.
Source : CC Pace Systems, Inc.
