Specialist - Technology Services

Job Description

Position Summary The SQL Database Administrator is responsible for the design, implementation, and support of database systems for applications across the Enterprise. Database Administrator is a part of the Database end to end delivery team working and collaborating with Application Development, Infrastructure Engineering and Operation Support teams to deliver and support secured, high performing and optimized database solutions. Database Administrator specializes in the SQL database platform. 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 Bachelor s degree in computer science, Information Systems, or another related field with 3+ years of IT and Infrastructure engineering work experience. Experience (In Years) 3+ Years Total IT experience 2+ Years relevant experience in SQL Server + Sybase Database Technical Skills Database Management: Should have Basic knowledge in managing and administering SQL Server, Azure SQL Server, and Sybase databases, ensuring high availability and optimal performance. Data Infrastructure Security: Basic knowledge 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: Basic knowledge 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 . Basic knowledge analytical skills to improve application performance. Basic knowledge of database performance Tuning, Backup Recovery, Infrastructure as a Code and Observability tools (Elastic). Strong knowledge in ITSM process and tools (ServiceNow). Ability to work 24*7 rotational shift to support the Database platforms Other Critical Requirements Automation tools and programming such as Ansible and Python are preferrable Excellent Analytical and Problem-Solving skills Excellent written and oral communication skills, including the ability to clearly communicate/articulate technical and functional issues with conclusions and recommendations to stakeholders. Demonstrate ability to work independently and in a team environment