Sql Database Administrator

Accomplished SQL database developer and SQL database administrator professional with 15 years of IT industry experience in developing, testing, and maintaining databases and data warehouses. Proficient in SQL programming, ETL processes, BI tools such as Tableau and Power BI and Data modeling tool ERWIN. Strong analytical skills combined with the ability to translate complex data into actionable insights for decision-making. Multi-skilled and extensive hands-on expertise in areas like Developing, testing, Implementation, T-SQL writing Stored Procedures, Views, Triggers, Indexes, Joins, User Defined Functions, Cursors, Backup, Restore, and Exposure on Mirroring, Clustering, log shipping. Have managed large data lead global engagements leading digital transformation, product transformation, and service management for MNC clients.

Core competencies include sound delivery / technical background, people, and quality management skills. Experienced in building software/product development, troubleshooting performance problems, fine-tuning databases, and index Analysis. Experienced SQL Developer proficient in accessing data via APIs utilizing tools like Postman. Skilled in seamlessly integrating external data sources into internal systems, ensuring data accuracy and reliability. Have experience in leveraging cloud technologies, particularly Google Cloud Platform (GCP), to enhance data management and analytics capabilities. Proficient in deploying, managing, and optimizing cloud-based solutions to meet diverse business needs. Skilled in utilizing GCP services such as Big Query, Dataflow, and Pub/Sub for scalable data processing and analysis.

Technology & R & D

Business Intelligence

ETL development

Delivery Management

Service redesign/delivery

Production management

shell scripting

Database Management

Project Management

Data modeling tool ERWIN

Client Relationship Management

Power BI

Experience History

Simple Solve Inc.

Pennington, USA

Senior Consultant

Aug 2023 to till date

Tata Consultancy Service Ltd

Chennai, India

Project Manager

Sep 2020 – Aug 2023

Sankara Nethralaya Medical Research Foundation

Chennai, India

Team Lead

Feb 2009 - June 2010

My professional experience includes working with Global companies and managing their IT services portfolio and product development from globally distributed locations and consistently providing customer delight.

Key accomplishments

12+ years of experience in Database Development and Administrator in SQL Server various versions like 2000, 2005, 2008, R2, 2012, 2014, 2016, and SQL Server 2017.

Defined the complete data warehouse architecture (e.g. ODS, ETL process, Data Marts, EDW, RTS).

Review, design, and develop data models, data mappings, and stored procedures with technical leaders and developers in support of ETL processes and software product needs.

Troubleshoot performance problems, fine-tuning databases, and index Analysis.

Expert at basic and advanced report creation (table, chart, matrix report, web reporting) along with excellent experience in report serving architecture.

Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.

Develop, test, and implement performance and resource optimization initiatives in consultation with development teams.

Excellent experience in developing complex stored procedures, efficient triggers, required functions, creating indexes, and indexed views for improving performance.

Expertise in Database Administration on Production Servers with server configuration, performance tuning, and maintenance with outstanding troubleshooting capabilities.

Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.

Expertise in T-SQL writing stored procedures, triggers, and functions.

Administering SQL Server High Availability and Disaster Recovery strategies.

Experience in using DMV and dynamic management functions for finding out long-running queries.

Experience in Disaster Recovery Planning and Security Management operations, and set up Log Shipping, Database Mirroring and Replication, and MSSQL Mail.

Set up security and access profiles and procedures for database system administrators.

Suggested, developed & implemented Scaling out solution with Data partitioning.

Suggested Application level tuning changes for code, queries, and SQL objects which may not be performing up to the optimum database performance standards.

Monitored the database server performance and if required go for tuning of the TSQL queries, Stored Procedures etc.

Assessed new and changed requirements and determined their impact on existing ETL routines.

Implemented the best practices and guidelines for Data Integration and Data Migration services.

Tools / Skills

Operating Platforms

Windows

Databases

SQL Server, Snowflake, MYSQL, ETL with SQL

Programming Languages

Asp.net, Java script

Big Data Ecosystems

Hadoop, HDFS, HBase, Zookeeper, Hive, Pig, Sqoop

Major Project Engagements:

Project Description 1

SimpleINSPIRE, a fully integrated Platform, is designed to meet the challenges of unprecedented transformation in the Insurance industry and take advantage of disruptive technologies, and digital abundance. Policy Management system is a platform with a visionary architecture and a foundation built on disruptive technologies for digital-first enablement. It empowers you to drive change rather than be driven by change. Introduce new norm policy products with confidence. The platform has an integrated insurance claims system to create and manage claims. A claim can have multiple claims features to manage multiple claims arising out of a single incident. Managing and reporting claims can be done at the Claim level or the Feature level. The SimpleINSPIRE – Insurance Claims system can create letter templates to generate claims-related correspondence providing operational efficiency.

Responsibility :

Working on SQL server development, SQL database administrator, Snowflake SQL, and Snowflake pipeline.

Proficient in Extract, Transform, Load (ETL) processes, with expertise in designing, developing, and optimizing data workflows.

Managing, troubleshooting, and resolving database and application-related issues

Experienced in using ETL tools and technologies such as Oracle Data Integrator, Informatica, and Talend to ensure the integrity and reliability of data pipelines.

Used COPY to bulk-load the data.

Production Database Administrations.

Developing SQL scripts, Stored Procedures, Views, Triggers, Indexes, Joins, User Defined Functions and Cursors, and procures/views in Snowflake.

Skilled in utilizing GCP services such as Compute Engine, BigQuery, Dataflow, Pub/Sub, and others to build scalable and resilient cloud architectures.

Checking of Cluster availability for Data Base servers

Installation of database server software.

Creating user IDs and defining roles, allocating quotas with necessary privileges for all databases.

Gathered requirements and Created data models for the databases.

Normalized data model for optimum performance.

Designed and Implemented Backup and Recovery Strategies and took backup using scripts.

Defining and Setting backup and recovery procedures

Developing backup scripts to automate the backup procedures.

Tuning and balancing I/O by monitoring file system and table space I/O statistics.

Re-indexing periodically

SQL and PL/SQL Programming

Project Description 2

Electronic Medical Records (EMR) - Major functionalities of EMR is a complete Electronic Clinical data of the patients, which is powered with various modules like Appointment List, IPEMR, OPEMR and Clinical Procedures & Tests. The application is tightly integrated with main modules of HMS like Appointment and surgery

Responsibility :

Working along with programmers and contributing to the development team process.

Managing, troubleshooting and resolving database and application related issues

Production Database Administrations.

Developing SQL scripts, Stored Procedures, Views, Triggers, Indexes, Joins, User Defined Functions and Cursors.

Checking of Cluster availability for Data Base servers

Installation of database server software.

Creating user ids and defining roles, allocating quotas with necessary privileges for all databases.

Gathered requirement and Created data model for the databases.

Normalized data model for optimum performance.

Designed and Implemented of Backup and Recovery Strategies and taken backup using scripts.

Defining and Setting backup and recovery procedures

Developing backup scripts to automate the backup procedures.

Tuning and balancing I/O by monitoring file system and table space I/O statistics.

Re indexing periodically

SQL and PL/SQL Programming

Project Description 3

Hospital Management System (HMS) Sankara Nethralaya is one of the world’s best ophthalmic care and research centers, which serves around 2000 patients a day. The center houses around thirty various departments, which efficiently manage patient care and medical services. The major functionalities of HMS is a fully integrated Hospital Management suit that is powered with various applications like Appointment Scheduling, Patient Registration, Billing, Clinical laboratories, Wards, Surgery Scheduling, Purchase, Pharmacy, and Stores.

Responsibility:

Developing backup scripts to automate the backup procedures.

Managing, troubleshooting, and resolving database and application-related issues.

Developed SQL scripts, Stored Procedures, Views, Triggers, Indexes, Joins, User Defined Functions and Cursors.

Installation of database server software.

Creating users, allocating quotas with necessary privileges and roles for all databases

Developing backup scripts to automate the backup procedures.

Tuning and balancing I/O by monitoring file system and table space I/O statistics.

Re-indexing periodically

Project Description 4

Medical Records Management System

Major functionalities of the MRD project involve the maintenance of Surgery details, Doctor Details, and Operation Theatre details.

Responsibility:

Developing backup scripts to automate the backup procedures.

Designing the MRD System.

Programming the application.

Testing.

Integrating with other modules of the HPMS.

Generating reports.

Developed SQL scripts, Stored Procedures, Views, Triggers, Indexes, Joins, User Defined Functions and Cursors.

Installation of database server software.

EDUCATION, RECOGNITIONS & AWARDS

Academics Master of Computer Application 2007

Academics Bachelor of Science 2004

Contact this candidate