Database Administrator

**About Data Axle**:
Data Axle Inc. has been an industry leader in data, marketing solutions, sales, and research for over 50 years in the USA. Data Axle now has an established strategic global centre of excellence in Pune. This centre delivers mission critical data services to its global customers powered by its proprietary cloud-based technology platform and by leveraging proprietary business and consumer databases.

Data Axle India is recognized as a Great Place to Work This prestigious designation is a testament to our collective efforts in fostering an exceptional workplace culture and creating an environment where every team member can thrive.

**General Summary**:
This position is responsible for designing, implementing, and maintaining marketing campaign software and work with infrastructure team. The Database/Application Administrator analyzes the needs of customers and maintains the marketing campaign platform to ensure accurate operations. This position is also responsible for ensuring the security and integrity of the client databases. The Database/Application Administrator also works directly with Data Axle vendor partners.

**Roles & Responsibilities**:

- Research, design and implement new marketing database systems based upon customer requirements.
- Evaluate new marketing database software features and related products, identifying improvement areas to create a more effective and efficient marketing database system.
- Define logical attributes and design complex data structures to accommodate marketing database production, storage, maintenance, accessibility, and to enhance performance.
- Coordinate with peers to determine impact of marketing database changes on other IT and business systems.
- Perform general technical troubleshooting to resolve marketing database performance and/or capacity issues.
- Setup and maintain documentation and standards related to database design and operations.
- Perform marketing campaign software testing and upgrades.
- Implement automated workflows to improve processes.
- Complete on call and after standard business hours work as required.
- Remain current on technology and trends in marketing campaign database administration.
- Perform other miscellaneous duties as assigned by management.

**Requirements**:

- Bachelor's degree in Information Systems, Information Technology, Computer Engineering or similar.
- Minimum 5 years of professional experience managing large scale Data Warehouse using AWS RedShift, RedShift Spectrum and/or RDS databases.
- Experience managing day to day operations of provisioning, maintaining backups, DR and monitoring of AWS RedShift/RDS clusters.
- Hands-on experience with Query Tuning in high concurrency environment
- Expertise setting up and managing AWS RDS and/or Aurora with MySQL & PostgreSQL.
- Experience writing Python scripts to automate DevOps tasks.
- AWS certifications are preferred.
- Familiarity with other AWS Services: S3, Lambda.
- Additional relevant experience in any relational database like Oracle or MSSQL or MYSQL or Postgres Database Administration is a must.
- Experience with software installation, upgrades, and patching.
- Experience with database operations, maintenance procedures, SQL.
- Experience with database design and data architecture design.
- Experience with performance tuning and database optimization.
- Updated on current on technology and trends in database administration.
- Automation of repeated activities and scripting experience.
- Knowledge of Linux system, hardware.
- Oracle OCI Cloud experience is a plus.
- Experience with Mongo, Redis is a plus.
- Experience with PL/SQL, T-SQL is a plus.
- Ability to communicate with individuals at all levels in the Company and with various business contacts outside of the company in an articulate, professional Excellent written and verbal communication skills are required.
- Skill in analytical thinking and problem solving.
- Ability to understand concerns and provide knowledge to computer users.
- Good analytical and problem-solving skills.

This position description is intended to describe the duties most frequently performed by an individual in this position. It is not intended to be a complete list of assigned duties but to describe a position level.