Home

ANIL P - Sr. SQL DBA

[email protected]

Location: Atlanta, Georgia, USA

Relocation:

Visa: H1B

ANIL Phone: 980-338-2017 SR. SQL SERVER DATABASE ADMINISTRATOR Email: [email protected] Over my 12 years career, I ve been involved in every facet of software design/development & Database Administration and understand product evolution through each phase of the software development lifecycle. I provide what's necessary for projects. Peers and clients to be successful and the strategy to implement it. Over 12 years of extensive knowledge and experience in Database Design & Database Administration. Out of which 9+ years as SQL Server DBA (SQL 2008/2008R2/2012/2014/2016/2017 and 2019) in Production, Development and Test Environments under Windows platforms. Broad knowledge of Information Technologies, and have successfully designed, developed, and deployed, enterprise applications. Experience in Installation, Configuration and Upgrading of SQL Server, Client Software and related products for Production, Development and Test Environment. Experience in Database Backup, Recovery and Disaster Recovery procedures. Broad knowledge of Information Technologies, and have successfully designed, developed, and deployed, enterprise applications. Experience in supporting Very Large databases (VLDB) Up to 90 TB size and troubleshooting. Expert in performance tuning and handling blocking situation and dead lock situations. Played a crucial role Migrating SQL Server 2014/2016/2017 to SQL Server 2019 Created and maintained the AlwaysOn availability groups on SQL Server 2019/2017/2016. Skilled with Integration, Reporting and Analysis Services. Experienced in creating technical documentations and process archiving and change management. Experience in creation of Database system, capacity and storage planning monitoring the parameters through DBCA utility and manual design. Backup and Restore VLDB databases using Veritas Netbackup, LiteSpeed, Data protector, Avamar and Tivoli. Implemented side by side and in place migration of MS SQL Server 2014, 2016 to 2017/2019 and applied patches and service packs to update different versions of MS SQL Server. Experience in Installation Configure and Administration of SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and PowerBI. Deep knowledge in Data Modeling (logical modeling and physical modeling) using Erwin. Worked in OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server. Extensive knowledge on Transparent Data Encryption (TDE) with Azure SQL DB. Strong experience in T-SQL Programming in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables, indexes and complex queries. Experience in ETL data using SSIS, DTS Import/Export Data, Bulk Insert, BCP and DTS Packages. Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities. Experienced in working with PBI reports and dashboards from multiple data sources. Managing both On-Premise and Cloud (Windows Azure SQL Database) SQL server instances Cloud/Azure experience includes Azure Services, Platform as a Service (PaaS), Infrastructure as a Service (IaaS), Software as a Service (SaaS) and Migrated from On-premises databases and Legacy databases to Azure, deployed products on Azure, Setup Dev/Test/Stage environments on Azure Experience in high availability SQL Server solutions, which include Log shipping, Replication, Mirroring and SQL Server clustering, Always On. Strong communication and interpersonal skills, the ability to prioritize and to make good sound decisions that benefit the company. I ve successfully delivered high quality, world-class solutions across industries, including, Healthcare, Technology, Insurance, Cloud Computing & Non-Profit Organizations I have extensive knowledge of designing both relational (3NF) and dimensional databases (HOLAP, ROLAP), vetting functional designs, performing impact and gap analysis of existing systems. TECHNICAL TOOLS SKILL SET RDBMS: Oracle 19c/12c, DB2, MS Access, SQL Server 2012/2014/2016/2017/2019. Scheduling Tools: UNIX Cron, SQL Server Agent. Data Modeling: ERStudio 11.x, ErWin 2020R2, SchemaSpy, Visio, Oracle Data Modeler Reporting: OBIEE, OBI Publisher 11g R1, Crystal Reports, Cognos and Tableau. Tools: MAP, Putty, TFS, Tivoli, Veritas Netbackup, SSMS, MS Visio, MS Visual Studio 2003, BMC Patrol, SolarWinds,IDERA Diagnostic Manager, Imperva SecureSphere Programming: Java, C, C++, T-SQL, SQL Plus, PL/SQL, UNIX Shell Scripting, Batch Scripting. Web Technologies: HTML, XML Environment: Win 7/XP/NT, Mac OS X 10 and later, UNIX flavors PROFESSIONAL EXPERIENCE Client: National Merit Scholarship Corporation Evanston, IL (Remote) Dec 18 Present Industry: Non-Profit Organization Roles: Sr. SQL Server Database Administrator (DBA)/Azure DBA The National Merit Scholarship Program is a United States academic scholarship competition for recognition and university scholarships administered by the National Merit Scholarship Corporation (NMSC), a privately funded, not-for-profit organization based in Evanston, Illinois. The program began in 1955.NMSC conducts an annual competition for recognition and scholarships: the National Merit Scholarship Program, which is open to all students who meet entry requirements, and until 2015 it also ran the National Achievement Scholarship Program (est. 1964), which was reserved for African American students. The highest-achieving students in the National Merit Scholarship Program are designated as National Merit Scholars. Responsibilities: Effectively Managing a SQL Server Environment and providing hands on DBA technical support to the NMSC Information technology team including management, software developers, production support and quality assurance testing teams. Installation, Configuration and Maintenance of MS SQL Server 2019/2017/2014 SQL SSIS, SSAS and SSRS. Cloud/Azure experience includes Azure Services, Platform as a Service (PaaS), Infrastructure as a Service (IaaS), Software as a Service (SaaS) Designed, building, installing, configuring, and supporting Database server Suggested application level tuning changes for code, queries, SQL objects that may not be performing up to the optimum database performance standards. Ownership of migration and manage all database environments Development, Testing, Stage and Production. Monitor and Maintain customers systems deployed in Azure for patching and security. Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing. Creating high availabilities like Mirroring, Replication and Log shipping for different Applications. Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases. Participating in SAN Migrations, Datacenter Migrations and OS Patching as per Change Management Schedules. Upgraded/Migrated SQL Server Instances/Databases from older version SQL Server to new version of SQL Server like 2012/2014 to 2017/2019. Installed and configured SSRS (SQL Server Reporting services), SSAS (SQL Server Analytical Services) and deployed SSIS (SQL Server Integrated Services). Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing. Scheduled many jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification. Worked with BI team, worked with building reports in PBI from scratch. Strong Experience in PowerShell Scripts, Batch processes, Import, Export, Backup, Database Monitoring tools, Data Transformation Services (DTS), SSIS, SSRS and Deploying SSIS Packages using Package Configuration and Deployment utility. Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases. Communication with NMSC IT Stake holders and management relative to technology and database environment verbally and in writing. Perform and report as an individual contributor and as a team member on projects assigned by NMSC management Environment: MS SQL Server 2019/2017/2016 Windows Server 2019 /2016 ,Microsoft Azure, .net 4.5, Visio, SharePoint, HP Service Manager, Active Directory, PBI, JIRA Ticketing, IDERA SQL Diagnostic Manager, Nagios, Confluence, Team Foundation Server (TFS), SSRS and SSIS. Client: Blue Cross & Blue Shield Association Chicago, IL Sep 17 Nov 18 Industry: Insurance Roles: Lead SQL Server DBA/MySQL DBA. Blue Cross Blue Shield Association (BCBSA) is a federation of 36 separate United States health insurance organizations and companies, providing health insurance in the United States to more than 106 million people. I was a lead SQL Server DBA/MySQL DBA maintained over 110 instances, responsible for designing, implementing and maintaining SQL Server and MySQL solutions in an Enterprise environment, and a self-motivated team player. Responsibilities: Provide infrastructure Database Administration (DBA) services across supported DB platforms including new database installations, software and patch level maintenance, performance and capacity management, disaster recovery, and overall database health. Partner with application DBAs and assist with tuning and optimizing query performance. Lead the DBA Team of 4 DBA s, lead the issues created reports and performed analyses on monthly system performance reporting issues to senior leadership team Perform database maintenance and backups and production DDL deployments according to established DBA Team standards, to be provided upon request. Configured and Managed AlwaysOn Availability Groups and Replica Databases with Database Snapshots for Adhoc Users to run queries on replica Databases Configured and Monitored Database Mirroring/Log shipping/Transactional snapshot and Merge Replications and troubleshooting of errors. Written PowerShell scripts that are customized for a particular dataset such as a morning health check, which outputs different base information on reporting every morning. Monitor system efficiency and recommend design and/or process changes to enhance performance and flexibility. Perform quality control and auditing of database environments to ensure database stability and performance efficiency. This includes evaluation of databases and associated servers with recommendations on improving performance where applicable. Perform configuration, maintenance, and optimization of database operations. Provide assistance in database and SQL statement tuning to improve performance. Monitor and review database access and security using Imperva to ensure policy compliance. Configure & monitor Alters in Solarwinds and PRTG Install, configure, and administer both development and production DB with MySQL 5.7.23 and oracle 9i and troubleshoot and resolve database problems occurring in production environments. MYSQL database performance tuning, backup and recovery and replication Serve as an expert resource for data modeling, scripting and writing stored procedures Perform root cause analysis troubleshooting, debugging and provide resolutions to database associated issues as required. Designed data Partitioning solutions for tables and indexes and Analyzed database growths for Capacity Planning, Normalized the data for efficient performance and Partitioned data into multiple Files and File groups. Developed DTS packages to extract, transform and load into the destination database from OLTP database. Involved in loading the partner flat files into the OLTP database. Also, developed the T-SQL stored procedures/functions to process these data and populate them in the appropriate destination tables Worked on a number of projects with multiple customers installing Imperva Agents and installation managers for database security. Upgraded Imperva Agents on a Regular Schedule every 3 months as per Imperva recommendations. Migrated SQL server 2012 to SQL Server 2016 in Microsoft Windows Server 2012 Enterprise Edition. Used the Imperva SecureSphere tool extensively to comply to SOX and HIPAA audits. Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients. Increased team productivity and automated repetitive tasks by using batch files, PowerShell Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS). Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2016 Enterprise Edition on SAN environment. Trained Junior database Administrator in the basic management of SQL Server DB engines. Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency. Configured Snapshot and Transactional Replication to replicate date to different environments. Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases. Make sure that all process related jobs/ maintenance plans completed which includes data pulling, file pulling, data update jobs etc. Environment: Windows Server 2012 and 2016, SQL Server 2016/2014/2012, MySQL 5.7.23, MySQL Workbench, SQL Query Analyzer, Windows Azure, .Net 3.5/4.0 IDERA SQL Diagnostic Manager, SolarWinds DPA, Power Shell, SQL profiler, DTS, SSRS and SSIS. Client: RxCrossroads/CVS Health, Louisville, KY May 16 Aug 17 Industry: Healthcare Roles: Sr.SQL Server DBA/Data Modeler Responsibilities: Participated in requirement gathering session with business users and sponsors to understand and document the business requirements as well as the goals of the project. Expertise in installing MS SQL Server 2014/2012/2008 R2/2008/2005/2000 and associated database tools, updating with latest service packs, hot fixes and security patches. Ownership of migration and manage all database environments staging, testing and production. Participating in SAN Migrations, Datacenter Migrations and OS Patching as per Change Management Schedules. Created entity relationship diagrams and multidimensional data models, reports and diagrams for marketing. Used Model Mart of ERwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement. used PowerShell to automate admin tasks Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets. Developed logical data models and physical data models using ER-Studio. Worked on the model based volumetric analysis and data based volumetric analysis to provide accurate space requirements to the production support team. Confirm all servers/databases are up and running fine on 24*7 environment. Created and upgraded SSIS packages for creating files and for ETL process. Built multiple SQL AWS RDS/EC2 instances and supporting those servers and instances Migrated SQL server 2014 to SQL Server 2016 in Microsoft Windows Server 2012 Enterprise Edition. Implementing high availability with AlwaysOn Availability Groups and failover clustering. AWS migration- RDS and EC2 instance creation and administration used PowerShell to manage SSIS packages across multiple SQL Server instances Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS). Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment. Created and configured an OLTP replication database for disaster recovery purpose. Experience on SQL Migration and Log Shipping, Replication, Database Mirroring and Clustering, Always On, MS SQL Azure, AWS RDS/EC2 instances Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various database and Files. Upload Data from MS Access, SQL Server to SQL Azure Trained Junior database Administrator in the basic management of SQL Server DB engines. Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency. Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files. Configured Snapshot and Transactional Replication to replicate date to different environments. Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases. Make sure that all process related jobs/ maintenance plans completed which includes data pulling, file pulling, data update jobs etc. Environment: SQL Server 2012/2014/2016 ERStudio 7.x, MS Visio, SchemaSpy, AWS, Oracle Data Integrator 12c, DTS, Backup Exec (Symantec), Avamar backups SSIS, SSRS, SSASSQL profiler, SSRS and SSIS. Rackspace Hosting, San Antonio, TX Aug 14 Mar 16 Industry: Cloud Computing Roles: Sr. SQL Server DBA As the Database Administrator, I was one of 4 DBA s who supported the company s entire global SQL Server estate. Tasks included day-to-day administration of the server, servicing of requests and releases, problem solving and resolution, and providing technical support to the company s database projects. Responsibilities: Installed MS SQL Server 2014, updating with latest service packs and security patches. Managing Databases spread across multiple servers in Production, Development, staging & testing Environments. Configured Snapshot and Transactional Replication to replicate date to different environments. Created and modified Stored Procedures, Functions and triggers. Backup and restore of databases as required. Designed a backup plan. Created Maintenance Plans to make sure the database does not encounter any issues. Optimized queries for better performance. Configured change data capture (CDC) at database level to capture the Changes on the tables. Used Profiler to identify long running queries and optimize them. Extensive Experience in System Auditing (SQL Server log, Windows Event Log, PSS Diag, SQL Diag), Design and Maintain the Security Principal to protect SQL Server from threats/attack, SQL Server Injection, Virus & warm and internal attack. Configured Log shipping/Transactional Replication and Mirroring for the mission critical application. Manage and maintain database changes in Development, QA, Staging and Production Create Maintenance planes for Database integrity checks and Index-rebuild on a Regular basis to maintain good database health. Designed disaster recovery model. Created and upgraded SSIS packages for creating files and for ETL process. Worked on comparing database, database objects between two environments using schema compare tool in visual studio 2008 Implemented new topics like CLR integration on Development server. Migrated DTS and SSIS packages from SQL Server 2008 to SSIS SQL server 2014. Evaluated data storage considerations to store databases and transaction logs. Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files. Installed, authored, and managed reports using SQL Server 2014 Reporting Services. Review T-SQL code to verify it meet standards for both performance and error handling according to DBA standards. Created Logon trigger to validate users connecting through different applications Used Performance Monitor/SQL Profiler to analyze long running /slow queries and tune the same to optimize Application and system performance. Worked with SharePoint developers in building custom web parts. Implementing the DDL triggers, Created DDL triggers to prevent accidental table drop and also to restrict access for unauthorized user. Maintained the database consistency with DBCC at regular intervals. Used tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor. Serco Group, Hyderabad, India July 11 July 14 Industry: Consulting Role: SQL Server Developer/Database Administrator Responsibilities: Converted logical Database Design into Physical schema using the balanced normalization in 2nd and 3rd Normal form for highest performance. Wrote Stored Procedures to implement business logic to maintain the history of entities which was also passed on to the application via Stored Procedures. 24 X 7 Production Database On Call Support. Successfully installed and configure SQL Server 2012 Migration of MS SQL Server from 2008 R2 to 2012 Scheduled Jobs and Alerts using SQL Server Agent. Improve the performance of SQL Queries and stored procedures using SQL Profiler, Estimated Query Plan and Index Tuning Wizard. Remote Monitoring of SQL Server 2008R2 and 2012 Transfer data from flat files, Excel spreadsheets to and from SQL Server using DTS, BCP and Bulk Insert. Created and managed users, roles and groups and handled database security. Manage and maintain database changes in Development, QA, Staging and Production. Configured database mail, Linked server and database mirroring as per the application requirement. Scheduling Full and Differential Database backups, and TLog Backups to disks, tapes or remote servers, using batch scripts, TSQL and Maintenance Plan Wizard and configure appropriate Recovery Model for the databases. Batch programming, stored Procedures, triggers with T-SQL and optimizing queries with Show Plan. Managed test data and their updates between development and production databases. Regularly monitor the system for bottlenecks (CPU, RAM, Disk IO) Use XML documents to pass multiple parameters for Stored Procedures to read and write database table. Also generate XML documents from tables. Document all process and Data Flow involved in the database for future reference. Design and Implement the Several SQL script to meet Regularity Compliance & Audit requirement for SOX application. Environment: SQL Server 2012/2008R2/2005, Windows 2012/2008 R2, IIS , Veritas Net backup, SQL LiteSpeed, MS Access, Excel, Crystal reports, Asp, Windows 2000 Advanced Server, Unix, Oracle and Windows NT. Keywords: cprogramm cplusplus quality analyst business intelligence database information technology hewlett packard microsoft procedural language Illinois Kentucky Texas