Clark Outsourcing Looking for IT Database Administrator at Bengaluru, Karnataka Full Time

Position Title: IT Database Administrator II

Salary Grade: 65,000 – 75,000 Pesos / month (95736.50 to 110465.19 Indian Rupees)

Reports To: Account Manager, Manager

Primary Relationships: Client, Client Team

Date: February 2023

Schedule : 9 PM – 6 AM PHT (6:30PM to 3:30AM IST)

Background:

The IT Database Administrator II will implement and manage the operational aspects of cloud-native and hybrid data platform solutions built with Microsoft SQL Server and Microsoft Azure Data Services. This role will use a variety of methods and tools to perform day-to-day operations, including applying knowledge of using T-SQL for administrative management purposes.

The IT Database Administrator II will be involved in the maintenance, deployment, and monitoring of database systems while ensuring security and a high level of data availability. This individual will be responsible for delivering high-quality, timely solutions and services through the full lifecycle, including development, testing, and implementation.

Responsibilities:

• Writes solid queries, stored procedures, functions, and triggers.
• Ensures accurate database indexing, archiving, reporting, and automation.
• Participates in periodic performance reporting, trend analysis to support in growth monitoring and capacity planning.
• Develops and supports ETL processes.
• Monitors database operations and performance using native and 3rd-party tools.
• Troubleshoots data-related issues while maintaining data integrity and accuracy.
• Evaluates database performance and analyzes drifts based on known baseline data.
• Participates in continuous improvement efforts in enhancing database performance and providing increased functionality, including performing maintenance, tuning, indexing, monitoring activity, and documenting problems, changes, and solutions.
• Arranges the implementation, administration, and usage of industry tools like SQL Server Management Studio, SQL Server Reporting Services, Google BigQuery.
• Plans and manages capacity of database management systems.
• Ensures appropriate jobs are scheduled to maintain nightly maintenance jobs.
• Documents database configuration and on-going management of configuration, continuous review of existing and creation of new database processes and procedures, periodic entitlement reviews.
• Ability to stay up to date with current trends and enhancements in the systems assigned that may add value to ATC.
• Looks for and proposes opportunities for ATC where the assigned system may be used in novel ways to competitively differentiate or accelerate ATC growth, market share and/or margins.

Requirements:

• Bachelor’s Degree in Computer Science, Information Technology, or related field
• 3-5 years of experience in a database administration/data engineering role
• Previous knowledge of IT concepts such as Database design, layout, structures, stored procedures, tables, optimization, TCP/IP, backup and restore, IT security concepts and practices is required
• 3 years or more of experience in at least one of the following:

o Microsoft SQL Server

o 3 years or more of experience:

o Writing stored procedures, queries, functions, and triggers in T-SQL

o Monitoring, troubleshooting and performance tuning database operations

o Delivering database code via CI/CD

o Troubleshooting SQL Server related CPU, memory, I/O, disk space and other resource contention issues, resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, connectivity issues, security issues, etc.

• 3 or more years of experience in the full software development lifecycle
• 1 or more years of experience working with cloud technologies (plus for Microsoft Azure)
• Familiarity with SSIS, SSRS and other ETL application support
• Experience in at least one Agile software development methodology (e.g. Scrum, Kanban)
• Strong collaboration and communication skills
• Ability to engage throughout the department and the company to achieve goals

COmpany Benefits:

• SSS, Philhealth, Pag-Ibig
• 13th Month Pay
• HMO and Life Insurance (AVEGA)
• Free Shuttle Service
• CO League – Monthly Company Activities
• CO Clubs
• CO Amenities Swimming Pool, Clinic and Kids zone
• CO Stars – Corporate Social Responsibility Involvement Scholarship Programs
• CO Academy – Training and Development Programs
• COolture Coach
• CO Gears
• Cool and Flexible Workplace
• Other Performance and Attendance Based Rewards
• Bereavement Leave
• Paternity Leave
• 7 days SOLO Parent Leave
• Magna Carta Leave
• Company Bank Loan

Job Type: Full-time

Salary: ₹95,736.50 – ₹110,465.19 per month

Schedule: