Senior Ecommerce Cassandra Database Administrator - Full-time / Part-time

The Home Depot is the leading retailer in home improvement across all channels - stores, online, and mobile. Online technology is a strategic investment area for the company and the driving force behind our interconnected retail strategy. We are looking for highly qualified technical leaders and innovators to fill key positions on one of the largest, fastest-growing eCommerce web sites in the world.
The Senior Ecommerce DBA will 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 and Works closely with the application teams and project managers as programs are developed. The position helps Designing and executing data management strategies including active performance tuning of the database DB instance and processes to support true 24x7x365 operations.

MAJOR TASKS, RESPONSIBILITIES AND KEY ACCOUNTABILITIES:-

• Create physical mid-sized database structures based on physical design for development, test, and production environments. Partner with DBA's and provide guidance on lower level projects.
• Work with system engineers to configure servers for DBMS product installation and mid-sized database creation.
• Configure and maintain DBMS product software on mid-sized database and application servers.
• Provide guidance to application development teams on DBMS product technical issues, techniques and SQL review.
• Provide on-call support for databases 7 X 24 to include being able to investigate, troubleshoot and resolve database problems
• Mentor and train other database administrators across lower level projects.

PREFERRED QUALIFICATIONS -

• 10+ years of Database Administration experience
• This role needs to be well rounded knowledge in e-commerce technology but highly technical on state of the art database platforms and infrastructures.
• Strong Java/J2EE experience
• In depth knowledge of architecting and creating Cassandra database systems.
• Experience in data modeling in Cassandra
• Must have hands-on experience in setting up Cassandra cluster
• Must have experience in monitoring and managing Cassandra cluster
• Experience in Datastax Enterprise version
• Must have experience in integrated Cassandra with Hadoop (Hive or similar) for Data aggregation
• Experience in code migration, database change management and data management through the various stages of the development life cycle
• Knowledge of Cassandra systems including but not limited to: backup and recovery, security and maintenance and tuning on both server and database.
• Experience in data migration from RDBMS to Cassandra.
• Proficient with operating systems software, networking tools, application development and multidimensional tools.
• 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
• BS Computer Science or related field
• Experience with DB2 LUW and MySQL database platform a plus
• Working knowledge of the complete software development life cycle.
• Working knowledge of relational databases, logical modeling, and data warehouse.
• Proficient with Data pruning strategy .This includes Discussing detailed plan with development team and client to identify any gaps or custom pruning areas needed Sign off by development team and Project manager and Client on all retention guidelines Coding of custom pruning areas if needed Scheduling of pruning scripts in crontab
• Knowledge of software development methods
• Support software development post-implementation/deployment phase

NATURE AND SCOPE -

• Typically reports to Manager, Information Technology
• Responsible for helping others and providing on-the-job training or guidance

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.

KNOWLEDGE, SKILLS, ABILITIES AND COMPETENCIES -

• Strong interpersonal skills, written and verbal communication
• Strong decision-making, problem-solving skills, critical thinking, and testing skills
• Exceptional analytical aptitude and attention to detail
• Ability to self-manage assigned tasks and projects
• Ability to work independently with minimal direction

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 - 5

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.