Database Administrator
Role details
Job location
Tech stack
Job description
This position is responsible for designing, implementing, administering and maintaining database technology solutions and the solutions that rely upon them. The Database Administrator must have experience working with application partners to define and satisfy requirements for solutions leveraging database technology. This position will be responsible for creating and maintaining related documentation to enable sustainable support., * 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.
Requirements
- Education: Bachelor's Degree in Information Systems, Computer Science, Computer Engineering, related degree or equivalent work experience.
- Years of Experience: 3 - 5 experience installing, configuring, administering, tuning, and troubleshooting database products and features for various application suites.
- Experience, as a Database Administrator, with recent/current versions of MS-SQL and Oracle database technologies running in virtualized server environments including Windows and Linux.
- Experience with database backups, recovery and cloning.
- Experience with performance troubleshooting, including hardware resource contention issues.
- Experience with RAC, AlwaysOn Availability Groups and/or other high availability technologies.
- Experience with application query tuning, including execution plan interpretation and SQL Profiler and/or Extended Events.
- Experience with database server software and patch installations.
- Experience with configuration and support of SQL Replication, Log Shipping, or other data movement technologies. Experience with Oracle Data Guard configuration and administration.
- Experience in T-SQL and PowerShell programming.
- Experience in PL-SQL and Linux Shell scripting
- Experience in Linux Server administration and performance review related to Oracle database needs.
- Experience automating processes utilizing scripting tools (bash, perl, python, etc.).
- Able to perform root cause analysis and recommend appropriate remedial actions.
- Demonstrably solid written and verbal communication skills to drive projects to successful conclusion.
- Self-motivated with excellent time management and organization skills. Able to acquire new skills autonomously.
- Demonstrated ability to document IT processes and provide knowledge transfer to team members.
- Must be willing and able to work beyond than normal work hours to resolve critical system problems and/or perform production system maintenance during emergency situations.
- Proven skills as a team member.
CRITICAL SKILLS & ATTRIBUTES
- Experience with administration of Teradata or Mongo DB solutions.
- Experience with cloud infrastructure (GCP, AWS, Azure).
- Previous retail industry experience.