Job Responsibilities
- 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
Education
Bachelors degree in computer science, Information Systems, or another related field with 14+ years of IT and Infrastructure engineering work experience.
Experience
(In Years)
14+ Years Total IT experience & 10+ Years relevant experience in SQL Server + Sybase Database
Technical Skills
- Database Management: Extensive Experience 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: expert 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.
- Expert in working Knowledge of database performance Tuning, Backup & Recovery, Infrastructure as a Code and Observability tools (Elastic).
- Automation tools and programming such as Ansible ,Python and Power Shell.
- Strong knowledge in ITSM process and tools (ServiceNow).
- Strong knowledge in AgriSafe Methodios .
- 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
