| Postgres DBA, USC or GC Only at Remote, Remote, USA |
| Email: [email protected] |
| From: Shikha, KPG99 [email protected] Reply to: [email protected] Hi, Hope you are doing well. Please find the job description below and let me know your interest. Position: Postgres DBA, USC or GC Only Location: Remote West Coast candidates will be considered Duration: 6+ Month MOI: Phone and Video Experience in AWS RDS The Postgres Database Administrator will support the databases utilized by our corporate and municipal customers. This individual will work under the guidance of the Database Manager to develop/support database solutions to support various company initiatives. Candidate must understand all aspects of database administration, and be comfortable working with developers to solve problems Key Responsibilities: Perform daily administration of Postgres (required), Oracle (desired), and SQL Server (desired) databases Install new releases, patch, and maintain databases Support daily DBA activities such as creating/removing database accounts, support of patching events, SOX/compliance evidence collection, working daily DBA ticket requests Analyze/tune databases to run at optimal efficiency Resolve issues with external and internally developed database applications Perform root cause analysis of issues/problems and create preventative measures. Ensure proper escalation and coordination of all issues. Execute action items resulting from Root Cause Analysis sessions to avoid future production defects Perform database cloning operations from production to test and development environments Develop, implement and monitor database backup and recovery procedures. Partner with software developers to review and provide advice on database design Perform capacity planning to ensure appropriate resources are deployed to meet business requirements. Implement DDL/DML scripts in support of SCRUM application release cycles Provide 24x7 production support, in an environment where uptime is critical Automate recurring tasks through a combination of SQL, PL/SQL, or scripting languages such as Perl, Bash, Powershell, shell scripting, etc. Assess and suggest opportunities for application and process improvement Promote adherence to departmental/software development standards Promote learning, understanding, and the general enablement of the DBA team Set a professional example for the team through model behavior, superior performance, and proper attendance Work independently, with the ability to overlap work schedule with US-based teammates Work after hours when required Required Knowledge, Skills & Abilities: 3+ years of database administration experience, with a primary focus on Postgres. Either Oracle or SQL Server experience also required (require Postgres + either Oracle or SQL Server) Bachelors degree in Computer Science or the equivalent combination of education, training, and experience Proficient in AWS RDS Postgres instances + on-prem Postgres Proficient with Unix/Linux command line interaction Ability to own and manage tasks and/or projects with minimal direction Ability to successfully troubleshoot issues/provide solutions with minimal direction Ability to learn new technologies/applications with minimal direction Capable to research and resolve issues with technologies outside of core competency Production Support Clustering/Replication Scripting skills such as PowerShell, Perl, shell scripting, etc. Database backups and all facets of recovery (simple restore, point in time recovery, etc.) VLDB Understand all aspects of database administration; be comfortable working with developers Clear and effective written and verbal English communications skills Strong technical and interpersonal skills with the ability to work with minimal supervision within a global staffing environment Proven analytical/problem solving skills. Ability to adapt in a dynamic environment. Ability to effectively communicate to technical staff (applications development and technical services) and management Can do attitude towards solving problems and completing tasks Preferred Knowledge, Skills & Abilities: Cloud-based Database administration (AWS, Azure, OCI) Oracle Goldengate replication Software Development experience Business Intelligence tools and concepts (ETL, SSAS, SSRS) Keywords: green card procedural language |
| [email protected] View all |
| Tue Oct 03 23:57:00 UTC 2023 |