.
*guadalajara, mexico*aeries /*payroll /*remote*database administrator (dba)*- 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 functions*:- 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.- provide managers 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.- implement monitoring and reporting capabilities to assist the team in rapidly identifying issues.- monitor the system daily and respond immediately to security or availability concerns.- participate in 24x7 on-call responsibilities, maintaining the availability and performance of all customer-facing production & cloud operations services.- accurately document all processes and procedures for routine and non-routine tasks of the position.- all other duties and responsibilities as assigned.
*qualifications requirements and skills*:- bachelor's degree in computer science or related field, or the equivalent knowledge and experience or professional training.- minimum 3 years of oracle goldengate administration and implementation experience.- minimum 3 years of microsoft sql server experience.- minimum 3 years of postgresql experience