| |
| - Manages design, distribution, performance, replication, security, availability, and access requirements for large and complex SQL & Sybase databases.
- Designs and develops physical layers of databases to support various application needs; Implements back-up, recovery, archiving, conversion strategies, and performance tuning; Manages job scheduling, application release, database change and compliance.
- Identifies and resolves problem utilizing structured tools and techniques.
- Provides technical assistance and mentoring to staff in all aspects of database management; Consults and advises application development teams on database security, query optimization and performance.
- Writes scripts for automating DBA routine tasks and documents database maintenance processing flows per standards.
- Implement industry best practices while performing database administration task
- Work in Agile model with the understanding of Agile concepts
- Collaborate with development teams to provide and implement new features.
- Able to debug production issues by analyzing the logs directly and using tools like Splunk.
- Begin tackling organizational impediments
- Learn new technologies based on demand and help team members by coaching and assisting.
|
Education, Technical Skills & Other Critical Requirement |
| Bachelor’s degree in computer science, Information Systems, or another related field with 10+ years of IT and Infrastructure engineering work experience. |
| 10+ Years Total IT experience & 7+ Years relevant experience in SQL Server + Sybase Database |
| - Database Management: expert in managing and administering SQL Server, Azure SQL Server, and Sybase databases, ensuring high availability and optimal performance.
- Data Infrastructure & Security: Expertise in designing and implementing robust data infrastructure solutions, with a strong focus on data security and compliance.
- Backup & Recovery: Skilled in developing and executing comprehensive backup and recovery strategies to safeguard critical data and ensure business continuity.
- Performance Tuning & Optimization: Adept at performance tuning and optimization of databases, leveraging advanced techniques to enhance system efficiency and reduce latency.
- Cloud Computing & Scripting: Experienced in cloud computing environments and proficient in operating system scripting, enabling seamless integration and automation of database operations.
- Management of database elements, including creation, alteration, deletion and copying of schemas, databases, tables, views, indexes, stored procedures, triggers, and declarative integrity constraints
- Strong database analytical skills to improve application performance.
- Should have strong working Knowledge of database performance Tuning, Backup & Recovery, Infrastructure as a Code and Observability tools (Elastic).
- Must have experience of Automation tools and programming such as Ansible and Python.
- Strong knowledge in ITSM process and tools (ServiceNow).
- Ability to work 24*7 rotational shift to support the Database and Splunk platforms.
|
Other Critical Requirements | - Excellent Analytical and Problem-Solving skills
- Experience managing geographically distributed and culturally diverse workgroups with strong team management, leadership and coaching skills
- Excellent written and oral communication skills, including the ability to clearly communicate/articulate technical and functional issues with conclusions and recommendations to stakeholders.
- Prior experience in handling state side and offshore stakeholders
- Experience in creating and delivering Business presentations.
- Demonstrate ability to work independently and in a team environment
|
