- Design, Architect, and build databases from determining business requirements to planning and deploying test and production systems.
- Administration of PostgreSQL databases throughout the development and production lifecycles in an AWS environment.
- Design and develop logical and physical database designs from customer requirements.
- Analyze/Develop business description of user needs, program functions, and steps required to develop or modify systems, including Business Requirements Documents and supporting documents, diagrams, data and database specification.
- Assist the project/application manager with release, configuration, and change management activities.
- Provide advice and support to development resources.
- Liaise with business customers and business analysts to support the design of intuitive end user reporting.
- Provide guidance in the creation and modification of standards and procedures.
- Provide mentorship to group members and will be expected to help develop and support mid and junior level staff.
- Provide advice and support to developers and testers.
- Provide guidance in the creation and modification of standards and procedures.
- Support the standards, policies and procedures of the DBA team.
- Collaborate with other DBAs and Infrastructure team members to develop automation scripts for managing databases and data in various environments.
- Scheduled for after hours on-call support and will be required to apply production packages during non-peak hours.
Basic Qualifications:
Minimum knowledge, skills, abilities needed.
- Bachelor's degree and 20 years of relative experience, Master's degree and 18 years of relative experience, or 24 years of relative experience in an IT field in lieu of a degree
- At least 7 years hands-on experience in database infrastructure tasks on Linux/Unix operating systems with demonstrated experience in each of the following:
- Installing databases preferably on-premise and Cloud PostgreSQL
- Designing/developing/maintaining database schemas
- Developing, writing, and testing of Linux or Bash scripts for startup, shutdown, backups, database scripts, and other scripting as required
- At least 5 years of experience in database administration tasks such as DB analysis, maintenance, development, and reporting
- Must be able to obtain and maintain a US Public Trust clearance
Preferred Qualifications:
Candidates with these skills will be given preferential consideration.
- Experience with deployment of AWS Cloud Infrastructure
- Experience working in a cloud environment like AWS cloud
- Experience and in depth knowledge of AWS database offerings (e.g. RDS, Aurora, and Dynamo).
- Experience setting up and managing PostgreSql on AWS RDS and AWS EC2 Virtual Server.
- Knowledge of PostgreSQL Architecture.
- Knowledge of pgbadger reports
- Experience with data architecture, logical and physical design, reporting and analysis.
- Experience with large enterprise solutions including but not limited to high availability, disaster recovery, and data management.
- Experience with transforming data from Legacy databases into archival data stores.
- Experience with Jenkins CI/CD tools and scripting.
- Experience with Liquibase and LiquiGen plug-in.
- Experience with Replication and Change Data Capture (CDC) techniques and tools.
- Experience with data conversion and management strategies
- Experience with database partitioning and micro-services
- Prior SSA experience