Lead Database Administrator - Ecommerce Database Engineering
Home Depot - Austin, TX

This job posting is no longer available on Home Depot. Find similar jobs: Lead Database Administrator jobs - Home Depot jobs

POSITION PURPOSE -
Do you want to be part of a thrilling revolution influenced by technology? The Home Depot is a $70 billion business-focused environment where you can contribute in a variety of functional areas covering all aspects of the consumer value chain. We are currently managing leading software packages and technology platforms to deliver creative results to our business partners and customers. We need people who understand how best to apply technologies to solve problems and develop innovative solutions. If you are looking for an opportunity to see instant, progressive, and substantial business benefits from your technology talents and experience, it's the perfect time to join The Home Depot.

As an IT professional you have expert knowledge in one or more programming languages or databases. Because of your excellent understanding of the entire project life cycle, you have the ability to direct project teams in the gathering, design, and development of complex applications/programs. You get to work closely with and learn from the brightest minds to ensure proper system design. Your role ensures highest quality implementations from design through quality insurance to production. You anticipate hardware and software design needs to take pre-emptive action. Our IT professionals support multiple team members and other project leads in day-to-day activities related to project work.

On- site and local perks:
Choose from a variety of benefit plans designed to meet your individual and family needs.
Take part in company Success Sharing - an incentive program based on sales performance.
Receive "Homer Awards" that lead to cash incentives for consistently demonstrating behaviors that reflect The Home Depot's values.
Eat at our on-site cafeteria that offers a plethora of options or enjoy discounts at neighborhood restaurants.

The Lead DBA manages the physical data stores for the enterprise. This includes working with data modeling and development teams to put processes and procedures in place to create new databases, replicate data across platforms, monitor and manage the databases in production, perform tuning and SQL analysis, provide space estimates, grant data level access privileges and provide consultation to application development teams on design issues. The Lead DBA has expert knowledge about database platforms and independently leads the implementation for high priority and complex enterprise databases. Coordinate and lead the definition of database backup/recovery and security strategies. Responsible for mentoring and training other database administrators, managing task assignments for junior database administrators, reviewing work and providing input to performance reviews.

In the role of Lead Database Administrator, this person will be responsible for:
Operating the databases that power one of the largest eCommerce websites in the world
Overseeing the design, implementation and deployment of large scale web and database infrastructures that are highly available, performing, cost effective, and sustainable
Defining and delivering robust monitoring solutions for database tier that encompass both infrastructure and application level perspectives
Active performance tuning of the database including DB instance, underlying OS and SAN infrastructure, and application SQL. Employ technologies such as application caching, table partitioning, compression, read-only instances, SSD storage, etc to improve performance
Designing and executing data management strategies including purge/archival and test environment data copying.
Planning and leading operations projects such as Holiday Readiness, performance tuning, data management, new environments, monitoring, etc.
Providing input into annual budget planning for new database infrastructure and tooling
Analyzing incidents, performance, metrics, and trends to proactively identify and resolve potential site issues before they develop.

This is a highly technical role. This person should possess a wide breadth of web operations and database knowledge. Must design and implement database infrastructure and processes to support true 24x7x365 operations. Expectation is no downtime for database maintenance.

MAJOR TASKS, RESPONSIBILITIES AND KEY ACCOUNTABILITIES -
Review physical database structures using complex technical skills based on physical design for development, test, and production environments.

Responsible for complex database performance tuning, security, database backup/recovery strategy, and implementing monitoring procedures to maximize availability of the database.

Mentoring and training of other database administrators, managing task assignments for associate database administrators, reviewing work and providing input to Manager.

Implement monitoring procedures to maximize availability and performance of the database, while meeting defined targets.

Provide consultation to application development teams on DBMS product technical issues, techniques and SQL review.

Coordinate with system engineers to configure servers for DBMS product installation and complex database creation.

Configure and maintain DBMS product software on complex database and application servers.

NATURE AND SCOPE -
Typically reports to Manager, Information Technology

No associates report to this role on a permanent basis, but requires the leadership of a work group: assign and review work, train and contribute to performance appraisal (but not hiring, firing or disciplinary action).

ENVIRONMENTAL JOB REQUIREMENTS -
Located in a comfortable indoor area. Any unpleasant conditions would be infrequent and not objectionable.

Typically requires overnight travel less than 10% of the time.
ESSENTIAL SKILLS

MINIMUM QUALIFICATIONS -
Must be eighteen years of age or older.
Must pass the Drug Test.
Must successfully complete any required training or orientation courses

EDUCATION REQUIRED -
The knowledge, skills and abilities typically acquired through the completion of a high school diplomas and/or GED.

YEARS OF RELEVANT WORK EXPERIENCE - 8

PHYSICAL JOB REQUIREMENTS -
Most of the time is spent sitting in a comfortable position and there is frequent opportunity to move about. On rare occasions there may be a need to move or lift light articles.

PREFERRED QUALIFICATIONS -
Extensive experience supporting a large scale, 24x7x365 website running on a DB2 database and AIX platform
This person needs to be well rounded in ecomm technology but highly technical on state of the art database platforms and infrastructures.
Experience with DB2 9.7 running on AIX 7
Experience with high availability clustering technologies such as HADR, TSA and Storage Technologies such as snapshot/BCV Copies
Experience with multi-data center hot/hot, hot/warm application and database architectures
Experience with MySQL database platform a plus
Strong communication and leadership skills to handle high-stress situations that require quick thinking and teamwork
Large scale eCommerce or Web Operations experience a must; retail experience strongly preferred
Websphere Application Server 7 and Websphere Commerce 7 experience is a plus
10+ years of Database Administration experience
BS Computer Science or related field
Strong Q-Replication/SQL-Replication experience is needed

KNOWLEDGE, SKILLS, ABILITIES AND COMPETENCIES -
Expert knowledge of the complete software development life cycle.

Significant experience with operating systems software, networking tools, application development and multidimensional tools.

Expert knowledge of relational databases, logical modeling, and data warehouse.

Ability to work independently with minimal direction.

Ability to communicate to a wide variety of technical audiences.

Ability to lead and mentor others.

Home Depot - 20 months ago - save job - - block
Recommended Jobs
Data Base Administrator V
Texas Parks and Wildlife Department - Austin, TX
Texas Parks and Wildlife Department - 20 hours ago

Cloud Systems Administrator
RateGenius Loan Services, Inc. - Austin, TX
Indeed - 11 days ago
Easily apply

Business Intelligence Analyst
ZeniMax Online Studios - Austin, TX
Gamasutra - 9 days ago
About this company
9,693 reviews
The Home Depot is the global leader in home improvement and fourth largest retailer in the world. Providing superior customer service and...