*Job Title Postgres AWS Database Admin*
*Location Remote*
*Duration 6+ month*
*Job Description *
*Cloud formation, migration, RDS, AWS, PostgreSQL*
We have a long term contract for a DBA engineer.
Due to the nature of the work,
*Seeking a Database Administrator (DBA) to join our team in support of our Federal Health IT customer.
The DBA will be responsible for designing, testing, planning, implementing, protecting, operating, managing, and maintaining our system's databases.
*
*This position is approved to be fully remote within the United States.
*
*Responsibilities Include:*
· Provision, configure and maintain RDBMS in AWS RDS using IAC (CloudFormation) Scripting.
· Create, tune, implement and upgrade DBMS installations.
· Monitor database operations and system performance metrics to identify potential risks/issues using AWS Monitoring Tools.
· Respond to performance and outage alerts
· Ensure database backup and recovery jobs are in place and regularly tested
· Manage database user access and security.
· Ensure database access controls support protecting the data.
· Optimize application SQL queries and database for faster performance and high availability.
· Write, deploy, as well as peer review, SQL DML and DDL script to support application patches and deployments using Liquibase
· Proactively and regularly make recommendations for system improvements.
· Collate, prepare, and present statistical information for internal and external use.
· Support application and database production deployment for application modules.
· Provide database guidance and support to project teams.
· Assist with schema design, code review, SQL query tuning.
· Work in conjunction with the data architect and application development teams to design, develop and review data model changes.
· Review and maintain database changes using Liquibase.
· Assist with SQL development to generate ad-hoc reports from database as needed.
*REQUIRED SKILLS/EXPERIENCE:*
· 3+ years of experience in administering, managing and tuning databases
· 2+ years of experience with Postgres DBMS
· 2+ years of experience with managing RDS in AWS
· 1+ years of experience with data modeling
· 2+ years of experience with Postgres Stored Procedures, Triggers Development
· 2+ years of experience with programming languages such PL/SQL coding
· Strong verbal and written communication skills to articulate complex technical concepts clearly and concisely
· Ability to maintain proactive and effective communication as a remote employee, ensuring seamless collaboration with team members and stakeholders.
· Experience as a database developer to assist development teams
· Experience with implementing and using Liquibase to manage database changes
· Implement and maintain company data management practices and policies
· Good understanding of data and schema standards and concepts
· Good understanding of database design, implementation, troubleshooting and maintenance
· Experience working in an Agile environment
· Sense of ownership and pride in your performance and its impact on company's success
· Critical thinker and problem-solving skills
· Team player
Good time-management skills
Great interpersonal and communication skills
Due to the requirements of our federal client, a minimum of Green Card status is required, and all applicants shall have lived in the United States for at least three (3) out of the last five (5) years
Must be able to pass a client-specific Public Trust background investigation
Must be able to pass a comprehensive background check
*Desired Experience and Qualifications:*
· AWS Certified Database - Specialty
· Experience with at least one other relational database including Microsoft SQL Server, MySQL, or Oracle
· Prior experience with scripting (Python, JavaScript, Shell (Linux or Windows))
· ETL experience using a data integration tool like Informatica, or Talend preferred
· Jasper Reporting experience
_*Aditya Kumar*_
*Stellent IT*
*Phone*: 7327959133
*Email*:aditya@stellentit.
com
*Gtalk*:aditya@stellentit.
com
Job Type: Contract
Salary: From $60.
00 per hour
Schedule:
* 8 hour shift
Work Location: Remote
Whatsapp
