Title: Senior PostgreSQL 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.
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
§ Chose proper resource type and size when provisioning AWS RDS
database related
§ resources to reduce expenses
§ Ensure all database related audits information is collected in
a timely manner.
Cloud Systems Design and Management
§ Design and implement AWS Cloud databases systems to ensure
failover and monitor capabilities are in place for 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 practice to design and creation of database
resource using CDK and ci/cd pipelines
§ Create, maintain and implement Aurora Postgres Database clone
from one environment to multiple environments.
§ Continue to implement, improve, and secure database systems to
enhance users’ management and databases resources monitoring.
§ Working 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,
Strong candidates will demonstrate the following abilities:
Critical Thinking Can break problems down into manageable,
ordered components and effectively communicate issues and plans
to others. Demonstrates the ability to use different
problem-solving strategies and select the one that best meets the
requirements of the situation. Gathers data to support
recommendations and seeks approval before taking action to
minimize risk and maximize impact.
Good Judgment Takes self-governed, consistent, action to
prioritize and weigh cost and value to determine the action most
appropriately aligned with organizational goals. Keeps the big
picture in mind while focusing on specific issues. Weighs risks
and tradeoffs reasonably. Reliably escalates when necessary.
Independent Can work on complex problems and completely new
tasks within time constraints. Takes a deep sense of ownership in
their work, no matter how small the task.
Collaborative Eager to help teammates solve problems and tackle
challenges. Willing to get “hands dirty” with day-to-day tasks.
Takes initiative to actively participate in team interactions.
Draws on the strengths of fellow team members. Actively seeks
opinions and ideas from people of varied background and
experiences to improve decisions. Willing to solve hard problems
and help generate creative solutions.
Influencing Demonstrates strong and consistent influence skills,
working effectively with staff, to present logical and compelling
arguments. Explains the immediate context of the situation, asks
relevant questions with follow-ups, and seeks advice prior to
acting. Can effectively distill and communicate complex technical
concepts to non-technical staff. Communicates effectively.
#PostgreSQL
#AWS
#Oracle
#DBA
