Login for faster access to the best deals. Click here if you don't have an account.

Database Administrator Full-time Job

3 months ago Public Service Elk Grove   265 views
Job Details
Position Summary
As a member of a lean and high-performing 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 MySQL, Oracle, MS SQL Server, and multiple common document-oriented databases. This position reports to the Senior Database Administrator.
 
Daily operational and development duties of a Mid-Senior Database Developer/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
  • 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
Breakdown of job duties (approximate)
  • 50% - Database development and administrative technical enablement, and collaboration with application team members, assigned to Agile story work, elaboration exercises
  • 30% - ITOPS duties: Ticket handling, audit, plan, patch, test, and implementing of changes
  • 15% - Document processes, procedures, configuration settings and infrastructure design for business continuity and disaster recovery
  • 5% - Includes on-call activities
Technical Qualifications
The Mid-Senior Database Administrator shall possess 7+ years of technical knowledge, and experience with most of the following systems, platforms, and/or applications:
  • Hands-on/applied experience in database development/administration using MySQL, Oracle, common document-oriented databases; including performance monitoring, capacity and multi-site disaster planning, transaction workload balancing, and performance tuning
  • Oracle 19C: Real Application Clustering, ASM, Data Guard, or GoldenGate
  • MySQL 5.7, 8: NDB, Multi-master, or Circular Replication, or Group Replication
  • Common document-oriented databases: MongoDB, CouchDB, Couchbase
  • Experience with Java ORM is a Plus: Spring JDBC, Spring Data, or JPA, JDBC
  • Extensive knowledge with complex SQL and PL/SQL programming, and optimization
  • Experience in Agile database development and administration
  • Proficiency with Linux running in converged or hyperconverged environments - VMWare & physical
  • Experience in database schema design including logical and physical for large scale, highly available application systems
  • Good writing skills to provide documentation for DBA and software development teams
  • Strong knowledge/understanding of ITSM/ITIL support processes and methodologies, incident management, change control management, problem management
Desired Skills
  • 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
Company Description
AutoZone, Inc. is a specialty retailer and a distributor of automotive replacement parts and accessories. As of August 30, 2008, the Company operated 4,092 stores in the United States and Puerto Rico, and 148 in Mexico. Each of its stores carries a product line for cars, sport utility vehicles, vans and light trucks, including new and remanufactured automotive hard parts, maintenance items, accessories and non-automotive products. The Company also sells the ALLDATA brand automotive diagnostic and repair software. On the Web, AutoZone, Inc. sells diagnostic and repair information and automotive hard parts, maintenance items, accessories and non-automotive products through www.autozone.com. The Company does not derive revenue from automotive repair or installation services.