.POSITION SUMMARYThe Database Administrator will support Amazon Web Services (AWS), Linux and Windows environments, and Oracle, MSSQL Server, and RDS Aurora PostgreSQL Databases.
The Database Administrator will be responsible for all aspects of the production lifecycle of maintenance and administration, including but not limited to: deployment automation, product release and support, running a scalable production environment for hosting the ARCOS platform, maintaining application/database availability, and ensuring continuous 24x7 production uptime of our services.The Database Administrator needs to be familiar with AWS, Oracle DB, Oracle Goldengate and DataGuard, Microsoft SQL Server DB (EC2 and RDS), PostgreSQL DB(RDS Aurora), Linux and Windows administration, and SaaS operations.ESSENTIAL JOB FUNCTIONSThis is intended as an outline of the essential functions of the position.
Actual metrics that measure job performance may be set forth in separate performance management documentation.Perform database administration tasks in a Linux and Windows environment, including maintenance, troubleshooting, tuning, optimization, installation, upgrades, backup/recovery, data migration, and data replication.Design, develop, analyze, extract, load, and maintain data using Oracle, PostgreSQL, MSSQL Server, SQL, PL/SQL, Powershell, and Unix shell scripts (bash and ksh).Upgrade systems and processes as required for enhanced functionality and security issue resolution.Create projects designed to add functionality required by the company or to address ongoing high availability, disaster recovery, and business continuity capabilities.Engage in Agile team practices such as backlog grooming, release planning, sprint planning, and auto deployment.Design and implement optimal solutions that scale for very large data sets and learn best practices through code reviews and collaboration.Work closely with Engineering, Development, Quality Assurance, Professional Services, and Technical Support to resolve issues that will affect the success of the assigned product offerings and schedules.Determine future database needs and plans for database changes with departmental managers.Manage AWS infrastructure, including RDS, WAF/Shield, EC2, Security Groups, Route 53 DNS, databases, malware protection software, and other AWS services.Review application and database logs using Splunk.Provide manager with regular status reports on development projects.Create, configure, and manage production infrastructures utilizing modern cloud computing technologies.Coordinate configuration changes, installs, upgrades, planning, scheduling, and status reporting while following company change control procedures.Automate common maintenance tasks and code deployments.Triage and resolve complex problems, including database and system performance issues, that span multiple tiers of application/infrastructure