Database Administrator

Database Administrator

Administer Oracle and MS-SQL Databases (plan and perform database upgrades, apply database maintenance, design and maintain physical database layout, perform database reorganizations, design and implement backup and restore strategy, archiving strategy, maintain database security, administer database performance, manage database storage, database problem determination and resolution, etc.).

Implement and maintain the multiple databases that comprise the overall database technology environment (development, test, training and production).

Actively participant in complete full Software Development Lifecycle (SDLC) processes from design, flowcharting, development, testing, modifying and implementation. This includes ensuring proper integration with other systems.

Refresh and test environments.

Provide recommendations for enterprise architecture.

Participate in peer reviews on specifications, design and code.

Perform database data validation. Develop and test related routines.

Provide technical input and assistance in optimal database configuration to maximize system performance and availability.

Work closely with Quality Assurance and Operations to ensure smooth deployment of high-quality applications.

Design and implement approaches to improve database performance, capacity, and scalability.

Work with project teams to plan integration and implementation strategies.

Provide 24x7 on-call technical support.

Participate in business requirement gathering meetings to understand all aspects of the business (functionality, processes, technologies). Determine feasibility of requests. Identify best approaches to provide technology solutions to meet business needs. Provide detailed estimates (time, cost, resources). Define technical specifications.

Provide status reports for related project activity.

Define standards for physical data storage, maintenance, access and security administration.

Experience with administration of Teradata or Mongo DB solutions.

Experience with cloud infrastructure (GCP, AWS, Azure).

Previous retail industry experience.