Job Description
The 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 (less required) databases
-Install new releases, patch, and maintain Postgres, Oracle, and SQL Server 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 Skills & Experience
-3+ years of database administration experience, with a primary focus on Postgres; secondary focus on Oracle and 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
-Strong technical and interpersonal skills with the ability to work with minimal supervision within a global staffing environment
-Ability to effectively communicate to technical staff (applications development and technical services) and management
Nice to Have Skills & Experience
-Cloud-based Database administration (AWS, Azure, OCI)
-Oracle Goldengate replication
-Software Development experience
-Business Intelligence tools and concepts (ETL, SSAS, SSRS)
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.