As a member of Database Administration Team, you will be responsible for providing second-level support for our IT operations, product engineering, data services, and data analysis teams; responsible for managing RDMS and DBMS (relational, data warehouse, data lake, data mart, and operational data stores) services hosted in multiple datacenters. Areas of coverage include but are not limited to Oracle, MySQL, and multiple common document-oriented databases. Daily operational and development duties of a Database Administrator are: technical elaboration and enablement during application planning and engineering agile exercises, workload performance profiling and optimization, design/implement/maintenance of blue-green production environments, query optimization, and after-hours on-call support.

　　•Work closely with the IT operations, product engineering, data services, and data analysis teams to provide database development/administrative technical enablement.

　　•Provide advice/recommendations on database architecture, design and implementation.

　　•Establish database design conventions in best practice, assure conventions and standards are compliant and fully documented.

　　•Work with data modelers to review and optimize logical data models and implement them in physical database schemas using data modeling tools.

　　•Communicate with non-technical users and technical personnel on business and product delivery teams.

　　•Support and participate in the database change management and deployment processes.

　　•Develop and implement stored procedure verification tools that assist developers in troubleshooting and performance improvement.

　　•Develop and implement procedures for the synchronization between different database environments.

　　Qualifications

　　The Database Administrator shall possess 5+ years of technical knowledge, and experience with the following systems, platforms, and/or applications:

　　Hands-on/applied experience in database development/administration using Postgress,Oracle, MySQL, common document-oriented databases: including performance monitoring, capacity and multi-site disaster planning, transaction workload balancing, performance tuning.

　　Postgress 9,12,replication,backup and recovery, access management.

　　MySQL 5.7, 8: NDB, Multi-master, or Circular Replication, or Group Replication

　　Oracle 12c,19c: RAC, ASM, Data Guard, GoldenGate

　　Common document-oriented databases: Couchbase

　　knowledge of Oracle GoldenGate replication and data movement strategies

　　Responsible for orchestrating upgrades, backups, and provisioning of Postgress and Mysql database and oracle instances.

　　Maintain backups and perform disaster recovery in case a disaster recovery for Postgress and MySQL database instances and oracle RAC databases.

　　Manage database availability, Tablespace management, Role management, maintain optimal Performance, Postgress utilities pg ctl,psql for MySQL and Postgress and Oracle.

　　Provision MySQL, Postgress and Oracle instances, both in clustered and non-clustered configurations, replication configuration for Mysql and Postgress and Oracle.

　　Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM.

　　knowledge with complex SQL and PL/SQL programming, and optimization

　　Experience in database schema design including logical and physical for large scale, highly available application systems.

　　Hands-on knowledge of RedHat, CentOS, or any enterprise/community Linux platform

　　Experience in Agile database development and administration

　　Good writing skills to provide documentation for DBA and software development teams.

　　Experience with service management software: Atlassian Jira/Confluence/Jenkins, SMAX

　　understanding of ITSM/ITIL support processes and methodologies, incident management, change control management, problem management.

　　Preferred: Bachelor’s degree in Computer Science or related field

　　Job duties and desired skills

　　o50% - Database development and administrative technical enablement, and collaboration with application team members, assigned to Agile story work, elaboration exercises.

　　o30% - ITOPS duties: Ticket handling, audit, plan, patch, test, and implementing of changes.

　　o15% - Document processes, procedures, configuration settings and infrastructure design for business continuity and disaster recovery.

　　o5% - Includes on-call activities.

　　•Apply technical problem-solving skills daily.

　　•Be proactive with a focus on constant improvement and follow through at all levels.

　　•Demonstrate your ability to work in a fast-paced environment while balancing multiple priorities.

　　•Provide excellent oral and written communication skills.

　　•Analyze/troubleshoot all levels of server, application and network issues.

　　•Document, track and monitor technical issues to ensure timely resolution.

　　•Provide timely and thorough input for regular status reporting.

　　•Take ownership of issues, work independently or escalate as needed, and find creative ways to resolve problems.

　　•Perform other duties and special projects as required or assigned.