SUMMARY

• Around 10 years of experience in SME, Administration and DevOps using SQL server 2005/2008/2008 R 2/2012/2014/2016/2017 systems in Azure and AWS OLTPOracle and OLAP environment.
• Expertise and Interest include Administration, Database Design, PerformanceAnalysis, and Production Support for Large (VLDB) and Complex Databases.
• Worked on setting up Azure environment Jenkins Pipelines for deployments over lower environments like UAT’s, Stage, QA and Dev machines
• Implemented side by side andIn place Migration (Data center) of MS SQL server R 2/2012/2014/2016 and applied Patches and Service packs to update different versions of MS SQL server.
• Proficient in SQL server 2008 features like Data compression, Resource Governor, Backup Compression, Mail setup, Jobs, Alerts and Database Tuning Advisor.
• Experience in implementing and setting up DR Disaster Recovery and HA High availability solutions like Always Ondifferent Clustering (Active - Active) and Replication
• Experience in regular maintenance activities like Query Tuning, statistics update, Index rebuild, log file monitoring, temp DB monitoring, handling blocking, deadlock resolutions, and fragmentation issues.
• Explicitly used third party tools like Erwin, Lite speed and SQL sentry
• Expert in using Native tools like SQL Server Profiler, Database Tuning Advisorand Perfmon.
• Implemented Data center migration with cross platform implementation on AWS EC2 instance using DMS.
• Used AWSServices like EC2, S3, ElasticSearch, RDS, SNS Services for hardware and Release purposes.
• Design and implement solutions to enhance the end user experience utilizing vendor supplied APIs and web services
• Good Knowledge on using Unix, T SQL, PowerShell commands for Server performance.
• Expertise in reading and understanding execution plan and fixing query to execute with low cost using various operators depending on the scenario.
• Experienced with API’s deployments, Maintenance and troubleshooting applications on Microsoft Cloud infrastructure Azure
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and Windows logs for hardware related errors.
• Experience on creating and migrating Databases to DR sites on Azure Platform.
• Experience in documenting the Root Cause Analysis for various issues like memory and outage of database and related hardware failure.
• Knowledge on Postgres data warehousing concepts using Linux\Unix.
• Auditing of database for user’s transaction, login, database action and removing orphan users.
• Cleared HIPPA certification for PHI related compliance.
• Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools (Star Schema, Data-Warehouses, OLAP cubes, Partitioning and Aggregations), ETL Process (Data Extraction, Transformation layer) with DTS/SSIS, Data Cleansing, MSSQL Databases, DataBricks,Analysis Services (SSAS),Reporting Services (SSRS), Notification Services (SSNS) and MDX ad-hoc Reporting.
• Extensively used Repositories like Team Foundation Server (TFS) and Clear Case for Data Archival.
• Handled numerous Change Management requests on production servers.
• 24 X 7 Production Database on Call Support.
• Flexible, Enthusiastic and project-oriented team player with excellent communication skills and analytical skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS

Operating Systems: Azure Cloud, VM, MDOS, Windows NT/ 2008/2010/2012 R2/2016/2019

Databases: MS SQL Server 2017/2016/2014/2012/2008 , Mongo Db, My SQL, Postgres,Oracle, Db2, MS Office, Access 97/2000/2003

ETL and REPORTING Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data transformation services (DTS), SMTP server services

Database Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio, perfmon counters

Third Part Tools: Jenkins, Bamboo, Boomi,Spotfire, Erwin, Apache Lucene, Lite speed, Fog lite, Red gate, Web services, SQL sentry, DbAmp.

Languages: T-SQL, SAS, XML, Python, PowerShell, Linux & Unix.

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

SQL DBA

Environment: MS SQL Server 2005, 2008, 20012/2016/17 , My SQL,Oracle DB, Azure PaaS, Windows 2008/2010/2012 R2/2016/2017SQL, MS Access, ETL,Attunity, GitHub, TFS,Idera,Spot light, Service Now, Migration Assistance.

Responsibilities:

• Migrating Datacenter and SQL Databases from Sql server 2005, 2008R2 to Sql server 2017\2019 and Oracle DB using DMA.
• Worked on changing the Datatypes and compatibility issues for Migration.
• Development of ERP solution using architecture and Microservices.
• Captured detailed documentation of decisions and conversations leading to resolutions for conformance work.
• Ensured the business and IT teams were considering many perspectives (e.g. practical as well as theoretical, internal/external use, business vs. technical development) as they solutioned for term definition and related attributes.
• Oversaw the DataGovernance (DG) Business Glossary and process leading to creation/changes of Glossary assets.
• Installation of MongoDB on physical machines, Virtual machines as well as AWS.
• UNIXshell scripts for hot backups, SQL*Loader, export and import of database.
• Supported Production Environment and Appliedpatches under UNIX platform.
• Analyzing long running slow queries and fine tune the same to optimize application and system performance tuning.
• Fine-tunedreplication and SQL Agent jobs with SSIS packages for better DR availability.
• Critically evaluated information gathered from multiple sources and worked with customers to assess whether data conformed to datagovernance approved mappings and standards.
• Used Attunity for replication purposes of needed tables.
• Upgraded Mongo database server from MongoDB V2.6.11 to V3.0.
• Worked with the table partitioning mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
• UsedLucene/ApacheSolrto index the processed data to make use ofSolrsearch capabilities
• Automating IBM Filenetbackups using python scripts to transfer data in DR bucket.
• Provided 24 X 7 Production OLTP Database on Call Support.

Confidential, Memphis,TN

Lead SQL DBA

Environment: MS SQL Server 2008R 2/2012/2, Azure PaaS, SSIS, Oracle,Windows 2012R2/2016/2017SQL, ETL,AutoSys, TFS, Spotfire,Unix,Idera,AWS RDS, DbAmp.

Responsibilities:

• Migrating Datacenter and SQL Databases from Sql server 2008R2 to Sql server 2019 on Azure Platform using DMA.
• Good Understanding & Knowledge onCloud computing architecture, technical design and implementations including Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS)
• Deployed Azure IaaS virtual machines (VMs) and Cloud services (PaaS role instances) into secure VNets and subnets.
• Worked on Migrating Tables from SQL Server to MS Access.
• Designed and Consumed XML Webservices. using Microservices.
• Wrote various data normalization jobs for new data ingested into Redshift
• Performance tuning and stress-testing of NoSQL database environments in order to ensure acceptable database performance in production mode.
• Testing, evaluation and troubleshooting of different NoSQL database systems and cluster configurations to ensure high-availability in various crash scenarios.
• Used Autosys for mapping the jobs and Auto scheduler purposes.
• Migrated on premise database structure to ConfidentialRedshift data warehouse
• Creating SQL Server Agent Jobs to maintain and run various SSIS packages periodically or as scheduled
• Architecture and Capacity planning for MongoDB/ Cassandra clusters
• Backup & Recovery, Database optimization and Security maintenance.
• Worked on migrating Oracle databases to AWSRDS using utility AWS Database Migration Service (DMS).
• Extensively worked on Transparent Data Encryption (TDE) and Auditing
• Performance tuning of databases by windows performance monitor and SQL Profiler.
• Used Index tuning wizard to redesign and created the indexes for better performance

Confidential, Stlouis,Missouri

DEVOPS\SQL DBA

Environment: MS SQL Server 2008/2008R 2/2012/2014/16 , Oracle, Windows 2003/2007/2010/2012 R2, SQL, ASP.NET,SSIS,TFS,AWS RDS, Powershell, Jenkins,Fog light.

Responsibilities:

• Integrated Subversion and SQL agent jobs with Jenkins to implement the continuous integration\daily operational process.
• Migrating Databases from Sql server 2008R2 to Sql server 2016\2017.
• Provide 24*7 Application availability using Auto scaling Services, including configuring, defining and testing auto scaling policies and created alarms to call scale up/down policy.
• Designed and used GitHub and TFS as repositories for daily deployments on APIs.
• Installation of packages, patches, maintenance on production application.
• Analyzing long running slow queries and fine tune the same to optimize application and system performance.
• UsedData AdaptersandDatasetsof ADO.Net to manipulate data in the SQL server database
• Solely responsible in the designed and data feeds to load Teradata tables from Oracle and DB2 mainframe z/OS DB2 tables, VSAM or from flat files, using Fastload, Multiload and Informatica for ETL services, in addition to RC-Migrator from Platinum toolset.
• Responsible for design and maintenance of theSubversion/CVSRepositories, views, and the access control strategies for different parallel development teams
• Worked with code review tools like OpenGrokand indexing tool Lucene
• Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
• Creating alarms in Cloud and production environmentswatch service for monitoring server’s performance, CPU Utilization, disk usage etc.
• Identified and resolved databasePTO performance tuning and Optimization issues, database capacity issues and other distributed data issues.
• Experience in working on source controller tools like TFS, CVS, IBM Clear case, and GIT.
• Supporting applicationproduction team & developers while being On Call DBA.
• Creation of cloud formation Templates of existing environments to use in building similar environments in the same or different regions for HAAlwaysONHigh Availability
• Maintaining the database consistency with DBCC, DMV and DMF’s at regular intervals.
• Created a discussion group for cloud support team in shared point and maintained all documentationsin SharePoint.
• Developed and maintained fully automated account de-provisioning solution using Designed and Developed Logging and Monitoring for Microservices by fluentd.
• Created and Consumed Swagger to debug the application.
• Consumed Docker's to develop Container's for the Microservices.
• Designed and Developed Container Management Rancher to publish Containers.
• Experience working with Agile/Scrum environment.

Confidential, Atlanta,GA

SQL Server DBA

Environment: MS SQL Server 2008/2008R 2/2012/2014/16 , Windows 2003/2007/2010/2012 R2, SQL, MS Access, SQL sentry, Powershell, Lite Speed V8.2.1.

Responsibilities:

• Installed and Upgraded from Sql Server 2008 to Sql server 2014& 2016 on various Production Servers R2 and upgraded to their respective Service Packs & cumulative upgrades.
• Implemented Sql Data Compression using Sql server 2008 for compressing data and Log Files, Back Up Level.
• Involved in Data center migration with cross platform implementation on AWSNo SQL Red shift EC2 instance using DMS.
• Installed SQL Server2014HADR Failover cluster.
• Worked on Azure SAAS and PAAS platforms, Performed Datacenter Migration to Azure Data Services for virtualization OLAP
• Worked on Cross Database Platform Migrations from SQL to My SQL, Oracle JD Edwards, Redshift AWS, Netezzaandpostgres
• Worked on various ASP.NET 2.0 web server controls that included Site Map Path, Menu, Tree View, Grid View and Details View to develop web forms.
• Migrating Databases from Sql server 2008 to Sql server 2014\2016.
• Created PowerShell scripts to constantly monitor the health of the Exchange messaging infrastructure and notify my teammates or myself in the event of a problem.
• Significantly reduced the amount of calls to the help desk by automating password expiration notification for users who did not log in to the network often with Windows PowerShell, making password-reset requests almost non-existent.
• Maintaining the database consistency with DBCC, DMV and DMF’s at regular intervals.
• Worked on ERM Integration process with JD Edwards Oracle tool.
• Wrote scripts and indexing strategy for a migration to Confidential Redshift from SQLServer, DB2 and Postgres databases
• Worked on AWS Data Pipeline to configure data loads from S3 to into Redshift
• Used Apache Lucene and JSON schema to define table and column mapping from S3 data to Redshift
• Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
• Scheduled jobs for backup and created alerts for error reporting.
• Solving Tickets on Daily Basis for Production Issues.
• Performed Backups, restores of databases usingErwin andLite Speed tool.
• Checking Database Health by using DBCC Commands.
• Supporting production team &developers while being On Call DBA.

Confidential, Columbus, Ohio

SQL Server DBA\Developer

Environment: MS SQL Server 2005/2008/2008 R2/2012, No SQL, .NET, Windows 2003/2008R2/2010, SSRS, SSIS.

Responsibilities:

• Managed and administeredOracle 11g and SQL server 2005\2008\R2\2012 servers
• Migrations of databases from SQL 2005 to SQL 2008 and SQL 2008 to SQL 2012
• Configured Windows Fail Over Clustering and SQL Clustering on Multi Subnet Cluster
• Migrating Databases from SQL Server 2008R2 to Teradata and Netezza DB systems.
• Create various reports using data sources including AWS- Redshift.
• Worked on good standard T-SQL queries by using different store procedures, Triggers, Indexes, Views.
• Configured Active Directory to create users and login groups to access failover clustering
• Performed installations of SQL 2005\2008\2012\2014 on clustered and standalone servers
• Worked on moving SQL databases to DR location on Azure Cloud.
• Upgradations of sql server versions and applying patches and hot fixes
• Adding nodes to already existing clustered servers as a part of data load\High availability
• Configured DR Transactional Replication and Log Shipping with SQL Server Management
• Implementation of SQL server logins, Roles and Authentication modes as a part of AD security policies
• Extensively worked on Transparent Data Encryption (TDE), Ideramonitoring and Auditing
• Used theADO.NETSqlClientObjects likeSqlConnection, SqlCommand, SqlDataReaderandSqlDataAdapterand Dataset object in the Data Access Layer to fetch the data from theSQL Server 2008database.
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs
• Tune slow running queries using SQL Server Profilerfor PTO issues
• Worked with database tuning advisor, SQL server profiler, Performance counters and activity monitor for Performance tuning
• Used DBCC and DMV commands for day-to-day troubleshooting tasks
• Import data across multiple instances using BULK INSERT and BCP Utility
• Involved in Capacity Planning, Database Normalization and De-normalization process
• Disaster Recovery Planning, Testing and analyzing and continuous update of documentation.

Confidential

SQL Data Engineer

Environment: SQL Server 2005(Enterprise Manager, DTS, IIS(Internet Information Service) Performance monitor and System monitor, Profiler, QA, Analysis Services), Windows 2003 Advanced Server.

Responsibilities:

• Performed backups, DBCC utilities, updated index statistics, monitored database and disk space.
• Created & maintained databases, users, Logins, tables, indexes, stored procedures, roles, permissions and other schema objects.
• Monitoring SQL server performance using profiler to find performance, Dead locks, blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Used Performance monitor and SQL Profiler to better tune SQL Queries and enhance the performance.
• Experience in identifying root cause analysis and fixing the Windows / IIS Web Server Related issues.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations.
• To set up SQL Server configuration settings.
• Designed and implemented comprehensive HA Backup plan and DR disaster recoverystrategies