DBA Engineer - PostgreSQL/Oracle, Mindlance, Washington, DC
Mindlance -
Washington, DC,
US
DBA Engineer - PostgreSQL/Oracle
Date Posted: 2024-05-21
Job description
Position Summary:
Title: DBA Engineer - PostgreSQL/Oracle
Duration : 6 Months Long Term
Location: Washington, DC 20005
Hybrid Onsite: 3 days onsite per week from Day 1.
The candidate should be fully vaccinated.
Essential Duties:
The positions essential duties include the following:
Type of experience:
EDUCATION:
Title: DBA Engineer - PostgreSQL/Oracle
Duration : 6 Months Long Term
Location: Washington, DC 20005
Hybrid Onsite: 3 days onsite per week from Day 1.
The candidate should be fully vaccinated.
Essential Duties:
The positions essential duties include the following:
- Administers, maintains, develops, and implements policies and procedures for ensuring the security and integrity of company databases.
- Implements data models and database designs, data access and table maintenance codes; resolves database performance issues, database capacity issues, replication, and other distributed data issues;
- Formulates and implements backup procedures for all company databases;
- Perform database related development as dictated by departmental or project demands;
- Experience with cloud database technologies (ie. AWS RDS, Oracle, MS SQL, Azure)
- Familiarity with AWS Cloud products (EC2, EBS, S3, Lambda, Aurora, Dynamo DB, EMR, DMS data migration, Athena, Glue, Kinesis, SQS/SNS, etc.);
- Exposure to the automation tools /scripting or processes;
- Knowledge of PostgreSQL and Oracle;
- Solid technical experience as a Database Administrator, as well as excellent interpersonal and communication skills;
- DB Concept on Security, Backup and recovery strategies, performance tuning, System Copies, high availability and disaster recovery strategy, export-import, replication is must;
- Hands-on experience with operating high-uptime Databases in both AWS and on-premises environments;
- Solid problem solving and analytical skills; able to quickly digest any issue/problem encountered and recommend an appropriate solution;
- Must be able to demonstrate experience with performance management/measurement methods, tools, and techniques;
- Ability to organize and plan work independently.
Type of experience:
- 4 6 years of increasing responsibility administering, optimizing, and maintaining PostgreSQL and Oracle databases .
- Demonstrated skill of formulating best practice recommendations for database operations, including backup strategy, data security and cloud platform
- AWS Cloud Database Technologies
- DynamoDB,
- AWS CLI,
- EC2, EBS, S3,
- Lambda,
- Aurora,
- EMR,
- DMS data migration,
- Athena,
- Glue, Kinesis,
- SQS/SNS, etc.
- Automation tools:
- Puppet,
- Ansible,
- AWS Cloudformation
- Terraform,
- Kubernetes
- Database Querying Languages
- PostgreSQL,
- Oracle
- Log Analysis
- Database cloud observability/monitoring tools splunk,solawinds
EDUCATION:
- Bachelors degree with a strong academic record.