Address
Form of workPosition Summary
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 Senior 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.
• Provide training and documentation for knowledge transfer to other database team members.
Qualifications
The Senior Database Administrator shall possess 7+ years of technical knowledge, and experience with the following systems, platforms, and/or applications:
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 strong 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.
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 Senior 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.
• Provide training and documentation for knowledge transfer to other database team members.
Qualifications
The Senior Database Administrator shall possess 7+ 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
- Advanced 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
- Extensive 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 advanced 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
- Strong knowledge/understanding of ITSM/ITIL support processes and methodologies, incident management, change control management, problem management
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 strong 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.
