| Postgres AWS DBA- Fully Remote at Remote, Remote, USA |
| Email: [email protected] |
| From: pankaj, Stellent IT [email protected] Reply to: [email protected] Postgres AWS DBA Fully Remote Phone and Skype Long Term Job Description: 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 Pankaj Kumar IT Technical Recruiter Phone : 321-766-9495 Email: [email protected] Gtalk: [email protected] Keywords: active directory information technology procedural language |
| [email protected] View all |
| Tue Jan 16 20:20:00 UTC 2024 |