SUMMARY:

• Overall having Around 11 years of IT experience in Database System Analysis, Design, Implementation and Administration of MS SQL Server 2019/2017/2016/2014/2012/2008/ 2005/2000 in Production, Test, Development and Replication & Cluster Server Environments.
• Worked as both Infrastructure DBA and Application DBA.
• Understanding in installing, upgrade, troubleshooting and configuration of MS SQL Server 2000/2005/2008/2012/2014/2016/2017/2019 and SQL Azure Database.
• Implemented always on high availability solution in Pre - Production and Production environments.
• Experience working with production and 24 x 7 on call environments and documenting all Database architecture according to established standards.
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
• Extensive Experience and in-depth working knowledge in various SQL Server tools and IDE to work with database, reporting and business intelligence based applications like SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, Visual Studio, and Query Analyzer.
• Excellent Experience in SQL Server administration, replication, database mirroring and log shipping.
• Experience in creating and maintaining SQL Clustering, Optimization, Backup, restore, Security and disaster recovery.
• Experience in developing and monitoring SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) Packages.
• Comprehensively involved in Data Extraction and Transforming and Loading (ETL) using DTS package in MS SQL Server 2000 and SQL Server Integration Services (SSIS), Import/Export data, Bulk insert and BCP
• Developed Drill through and Drill down reports using SQL Server Reporting Services (SSRS). Experience in developing User reports and management reports using MS SQL Server Reporting Services (SSRS).
• Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS).
• Experience in Creation and deployment of cubes on SSAS.
• Create and configure Logical SQL servers, databases, elastic pools in Azure Cloud.
• Monitor performance and setup alerts to avoid performance issues occurring on Azure databases.
• Extensively worked usingAWS and Azure service with wide and in depth understanding of each one of them.
• Experienced with Star and Snow-flake schema dimensional data modeling.
• Proficient in SQL database design, architecture, data modeling using Erwin.
• Excellent knowledge in RDBMS concepts and constructs along with Objects creation such as Database, Table, Normalization, UDF, User Defined Data Type, Indexes, SPROC, Views, Cursors and Triggers.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities, DMV’s, Backup and Recovery.
• Hands on experience with T-SQL(DDL, DML, DCL) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
• Organized professional with excellent oral and written communication skills, fast learner and also adapt quickly new technology with ability to take new roles in minimum time and little . Ability to work individually as well as in a team with excellent problem solving and trouble- shooting capabilities.

TECHNICAL SKILLS:

RDBMS/DBMS: MS-SQL Server 2019/2017/2016/2014/2012/2008/ 2005/2000, Oracle 11i, MS Access, Sybase.

Operating Systems: Windows 2019/2016/2012/2008/2003/2000, NT, UNIX, Linux.

DBA Tools: SQL Server Management Studio, SQL Server Business Intelligence Studio, SQL Profiler, Idera Tool set, SQL Lite speed, SQL Sentry and Redgate Tool Set

Reporting Tools: Reporting Service (SSRS).

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS), SQL Server Migration Assistant (SSMA)

OLAP Tools: SQL Server Analysis Services (SSAS).

Programming Language: T-SQL, PL/SQL, C#, ADO.Net and PowerShell

PROFESSIONAL EXPERIENCE:

Confidential, Plano TX

Sr. SQL Server Database Administrator

Responsibilities:

• Configuring the database Servers according to specifications from scratch, including working on server specs, and setting up Clustering and configuration of drivers according to company standards and database server needs.
• Involved in requirements gathering, analysis, design, development, change management.
• Worked on complex Stored Procedures and triggers to Modify data to meet business needs.
• Performed SQL Server cumulative upgrades and Service Pack Upgrades
• Maintained MSSQL databases for several in house and third party applications.
• Maintained and monitored routine tasks such as backups, restores, refreshing databases, Re-Indexing, constancy checks, Jobs status.
• Monitored SQL server Resources like CPU, Memory and Storage Usage.
• Create ad-hoc queries from SQL Server databases for custom reporting needs.
• Monitoring SQL server LOGS, Application logs (Event Viewer), Tuning SQL server databases using SQL Profiler, Performance monitor, database tuning advisor.
• Provided on Call Production support.
• Created SSIS packages for importing data into staging environment for Cleansing, Parsing, and Scrubbing by using SSIS tools before getting loaded into destination.
• Performed Performance Tuning on various Databases on Dev, Test, Pre-Prod and Prod.
• Database Administration and Support of MS SQL Server 2017, 2016,2008, in Production, QA, Test, Development in Standalone and Cluster Server Environments.
• Create and configure Logical SQL servers, databases, elastic pools in Azure Cloud.
• Import and Export data within Azure Cloud environment.
• Monitor performance and setup alerts to avoid performance issues occurring on Azure databases.
• Implemented and managed SQL Servers in Azure(IaaS) and AWS (IaaS).

Confidential, Irving TX

Sr. Database Administrator /Developer

Responsibilities:

• Configuring the database Servers according to specifications from scratch, including working on server specs, and setting up Clustering and configuration of drivers according to company standards and database server needs.
• Performed SQL Server cumulative upgrades and Service Pack Upgrades
• Maintained MSSQL databases for several in house and third party applications.
• Involved in requirements gathering, analysis, design, development, change management.
• Worked on complex Stored Procedures and triggers to Modify data to meet business needs.
• Create ad-hoc queries from SQL Server databases for custom reporting needs.
• Monitoring SQL server LOGS, Application logs (Event Viewer), Tuning SQL server databases using SQL Profiler, Performance monitor, database tuning advisor.
• Provided on Call Production support.
• Performed Performance Tuning on various Databases on Dev, Test, Pre-Prod and Prod.
• Database Administration and Support of MS SQL Server 2017,2016,2014,2012, 2008,2005 in Production, QA, Test, Development in Standalone and Cluster Server Environments.
• Implemented and managed SQL Servers in AWS (IaaS).

Confidential, Fort-worth TX

Sr. Database Administrator

Responsibilities:

• Installed stand-alone and clustered SQL Server 2012 and 2014 on 64 bit systems.
• Managed and administrated SQL Server 2012/2014/2016 on production and non-production server.
• Planned, executed and documented database Migration from SQL Server
• Performed Failover drill tests to check the High Availability during disasters.
• Performance analysis and production support for very large (VLDB) in OLTP, OLAP Database
• Configured and Maintained High Availability and disaster recovery Setups (Transactional Replication, 2 node and 3 node clustering, Mirroring and Log Shipping).
• Experienced in transparent data encryption (TDE).
• Installed, configured and administered Windows Server 2012 R2, Active Directory, and VMware
• Used Lite Speed for backups and maintenance jobs which include updating statistics, database integrity checks.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Used table hints in the queries to avoid locks in the server.
• Created missing indexes on the tables by running Data Base Engine Tuning Adviser.
• Finding and solving locks and Deadlocks by using DMV’s and DBCC commands.
• Monitoring SQL server LOGS, Application logs (Event Viewer), Tuning SQL server databases using SQL Profiler, Performance monitor, database tuning advisor.
• Provided on Call Production support.
• Managed SQL Servers in Azure(IaaS).
• Create and configure Logical SQL servers, databases, elastic pools in Azure Cloud.
• Monitor performance and setup alerts to avoid performance issues occurring on Azure databases.

Environment: MS SQL Server 2000,2005,2008,2012,2014,2016, SSIS, SSRS, SSAS, Microsoft.NET, MS Office Excel, C#, Visual Studio, Power shell, T-SQL

Confidential, Fort-worth TX

Sr. Database Administrator

Responsibilities:

• Configuring the database Servers according to specifications from scratch, including working on server specs, and setting up Clustering and configuration of drivers according to company standards and database server needs.
• Performed SQL Server cumulative upgrades and Service Pack Upgrades
• Maintained MSSQL databases for several in house and third party applications.
• Creating Automatic data loading Procedures using PowerShell from the host system to Data Collection Servers
• Security issues related to logins database users and application roles
• Involved in trouble shooting and fine-tuning of databases for performance optimization
• Tuning front-end applications like C#, ASP and MS Access, which query the databases. Troubleshooting ODBC and OLEDB issues between the application and the server
• Database Administration and Support of MS SQL Server 2014, 2012, 2008, 2005 in Production, QA, Test, Development in Standalone and Cluster Server Environments.
• Maintained and monitored routine tasks such as backups, restores, refreshing databases, Re-Indexing, constancy checks, Jobs status.
• Created SSIS packages for importing data into staging environment for Cleansing, Parsing, and Scrubbing by using SSIS tools before getting loaded into destination.
• Monitored SQL server Resources like CPU, Memory and Storage Usage.
• Trouble shooting Replication issues and configuring new Publications and Subscriptions.
• Configured and maintained Mirroring, Log shipping.
• Optimized existing replication by modifying agent profiles and agent parameters.
• Created maintenance scripts to optimize re-indexing Jobs.
• Writing Stored Procedures, Triggers, Cursors and creating indexes.
• Involved in Rewriting T-SQL code to optimize existing process.
• SSIS Administration including configuration, promoting packages, setting up batch process jobs.
• SSAS Administration including configuration, trouble shooting and monitoring processes.
• SSRS Administration including configuration, security management, trouble shooting and monitoring.

Environment: MS SQL Server 2000,2005,2008,2012,2014,2016, SSIS, SSRS, SSAS, Microsoft.NET, MS Office Excel, C#, Visual Studio, Power shell, T-SQL

Confidential

SQL Server Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management.
• Install, configured, and develop SQL Server 2014 DB engine, SSIS and SSRS, Data tools .
• Successfully managed Extraction, Transformation and Loading (ETL) process froma various data sources like Excel, flat files,SQL server and access databases .
• Applied various Data flow and Control flow transformations to meet the business needs.
• Worked on complex Stored Procedures and triggers to Modify data to meet business needs.
• Created database maintenance plans, regular scheduled DBA tasks for enhancing the performance of SQL Server.
• Designed and Created Databases, ETL, Reports to support business reporting and forecasting processes.
• Create ad-hoc queries from SQL Server databases for custom reporting needs.
• SSRS,SSIS Administration including configuration, trouble shooting and monitoring processes.

Environment: MS SQL Server 2014, SSIS, SSRS, Microsoft.NET, MS Office Excel, C#, ASP.Net, Erwin, Visual Studio, T-SQL

Confidential -Fort worth TX

Sr.Database Administrator

Responsibilities:

• Installed SQL Instances, service packs, and created new databases
• Performed Database cloning and restoration in UAT and Development environments
• Created Jobs and Job Schedules for Routine, Maintenance, Optimization tasks
• Validated Instances and databases are online, Monitored Background processes and agent status
• Captured and monitored Performance Statistics of Instances like IO, Waits, Paging, Buffer cache Hit Ratio
• Created Replication and performed Standby DR setup
• Verified Database integrity, Monitored free space in file groups and drives, Index Rebuilds/ Reorganising
• Conducted Backup, restoration drills for backup verification
• Performed Performance Tuning on various Databases on Dev, Test, Pre-Prod and Prod.
• Maintained regular backup jobs on all the environments
• Worked on migration from SQL 2005 to SQL 2012/2008R2 including databases, logins, users, jobs, DTS packages
• Created Logins, Users, groups, Roles, Jobs, Alerts, Mails confirmation upon tasks
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs

Confidential, Salt Lake City-UT

Sr. Database Administrator

Responsibilities:

• Configuring the database Servers according to specifications from scratch, including working on server specs, and setting up Clustering and configuration of drivers according to company standards and database server needs.
• Performed SQL Server cumulative upgrades and Service Pack Upgrades
• Maintained MSSQL databases for several in house and third party applications.
• Creating Automatic data loading Procedures using PowerShell from the host system to Data Collection Servers
• Security issues related to logins database users and application roles
• Involved in trouble shooting and fine-tuning of databases for performance optimization
• Tuning front-end applications like C#, ASP and MS Access, which query the databases. Troubleshooting ODBC and OLEDB issues between the application and the server
• Database Administration and Support of MS SQL Server 2012, 2008, 2005 in Production, QA, Test, Development in Standalone and Cluster Server Environments.
• Maintained and monitored routine tasks such as backups, restores, refreshing databases, Re-Indexing, constancy checks, Jobs status.
• Monitored SQL server Resources like CPU, Memory and Storage Usage.
• Trouble shooting Replication issues and configuring new Publications and Subscriptions.
• Optimized existing replication by modifying agent profiles and agent parameters.
• Created maintenance scripts to optimize re-indexing Jobs.
• Writing Stored Procedures, Triggers, Cursors and creating indexes.
• Successfully Developed Extraction, Transformation and Loading (ETL) process.
• Involved in Rewriting T-SQL code to optimize existing process.
• SSIS Administration including configuration, promoting packages, setting up batch process jobs.
• SSAS Administration including configuration, trouble shooting and monitoring processes.
• SSRS Administration including configuration, security management, trouble shooting and monitoring.

Environment: MS SQL Server 2000,2005,2008,2012, SSIS, SSRS, SSAS, Microsoft.NET, MS Office Excel, C#, Visual Studio 2010, T-SQL

Confidential

Sr. SQL Server Database Administrator / Developer

Responsibilities:

• Configured 2 node Active-Active and Active-Passive clusters for production server.
• Analyzing existing application and preparing technical requirements for migration.
• Implemented solutions like always-on, transactional replication and log shipping in both production and non-production environments.
• Migrating database schema and data using SSMA and SSIS.
• Converting Shell Scripts, Perl Scripts into SSIS packages to perform ETL process for batch loading.
• Created Maintenance standards like Index Reorganization, Tuning, Update Statistics, Maintenance plans etc.
• Converting Sybase and Oracle (PL-SQL) Stored procedures to T-SQL Stored Procedures.
• Modifying VB &Java DAO (Data Access Objects) to point to SQL Server from Sybase and Oracle.
• Deploying JAVA web applications to tomcat server and VB applications in client machines.
• Security issues related to logins database users and application roles and linked Servers.
• Involved in trouble shooting and fine-tuning of databases for performance optimization
• Tuning front-end applications like Visual Basic, Java and MS Access, which query the databases. Troubleshooting JDBC and ODBC issues between the application and the server
• Database Administration and Support of MS SQL Server 2008, MS SQL Server 2005 and Oracle in Production, QA, Test, Development.
• Writing Stored Procedures, Triggers, and Cursors and creating indexes.
• SSIS Administration including configuration, promoting packages, setting up batch process jobs.

Environment: MS SQL Server 2008, Sybase ASE, SSIS, Microsoft.NET, MS Office Excel, MS Office Access2003,VBA, Java, Visual Basic 6, Apache Tomcat, Perl, T-SQL

Confidential, Jacksonville, FL

Sr. Database Administrator

Responsibilities:

• Designing the database according to specifications from scratch, including working on server specs, and setting up Clustering and configuration of drivers according to company standards and database server needs.
• Maintained MSSQL databases for several in house and third party applications.
• Actively involved as part of team for gathering and analyzing the needs of end user requirement and translate these into and technical specifications.
• Creating Automatic data loading Procedures from the host system to master systems
• Security issues related to logins database users and application roles and linked Servers.
• Involved in trouble shooting and fine-tuning of databases for performance optimization
• Tuning front-end applications like Visual Basic and MS Access, which query the databases. Troubleshooting ODBC and OLEDB issues between the application and the server
• Database Administration, and Support of MS SQL Server 2008, MS SQL Server 2005 and Oracle in Production, QA, Test, Development in Standalone and Cluster Server Environments.
• Writing Stored Procedures, Triggers, Cursors and creating indexes.
• Successfully Developed Extraction, Transformation and Loading (ETL) process.
• SSIS Administration including configuration, promoting packages, setting up batch process jobs.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and cubes in Analysis Services (SSAS)
• Created maintenance plans to process Cubes and to load data into warehouse.
• SSAS Administration including configuration, trouble shooting and monitoring processes.
• SSRS Administration including configuration, security management, trouble shooting and monitoring.

Environment: MS SQL Server 2000,2005,2008,2012,T-SQL, SSIS, SSRS, SSAS, Microsoft.NET, MS Office Excel, C#, Visual Studio 2010

Confidential, Ft. Lauderdale, FL

SQL Server Consultant/Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management.
• Install, configure, and develop SQL Server 2005 Analysis Services (SSAS).
• Designed and Implemented data warehouse.
• Successfully managed Extraction, Transformation and Loading (ETL) process.
• Applied various Data flow and Control flow transformations to meet the business needs.
• Worked on complex Stored Procedures and triggers to capture updated and deleted data from OLTP systems.
• Created database maintenance plans, regular scheduled DBA tasks for enhancing the performance of SQL Server.
• Designed and architected of OLAP cubes to support business reporting and forecasting processes.
• Created maintenance plans to process Cubes and to load data into warehouse.
• Create ad-hoc queries from SQL Server databases for custom reporting needs.
• SSAS Administration including configuration, trouble shooting and monitoring processes.

Environment: MS SQL Server 2005, T-SQL, SSIS, SSRS, SSAS, Microsoft.NET, MS Office Excel, C#, ASP.Net, Erwin, Visual Studio 2005

Confidential, Miami, FL

Sr. SQL Server Consultant

Responsibilities:

• Assisted in complete Life Cycle including Design, Development and Testing of Data migration project from several legacy databases to newly designed SQL 2008 centralized database repositary.
• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Used Reverse Engineering to create a buffer Data base for Data Migration.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, Sybase etc) and loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages to meet business needs.
• Worked on complex Stored Procedures and triggers to capture updated and deleted data from OLTP systems.
• Created database maintenance plans, regular scheduled DBA tasks for enhancing the performance of SQL Server, some of these tasks included Database integrity checks and re-indexing.
• Created SSIS packages for importing data into staging environment for Cleansing, Parsing, and Scrubbing by using SSIS tools before getting loaded into destination.
• Applied various Data flow and Control flow transformations to meet the business needs.
• SSIS Administration including configuration, promoting packages, setting up batch process jobs.
• Developed tabular queries for efficient analysis of report using Pivot/Unpivot in T-SQL.
• Designed and deployed Reports with Drop Down menu option and Linked reports
• Developed drill down and drill through reports from multi dimensional objects like star schema and snow flake schema using SSRS and performance point server.
• Created subscriptions to provide a daily basis reports and managed and troubleshoot report server related issues.
• Implemented the Transactional Replication for off-loading the OLTP production environment from reporting.
• Used Execution Plan, SQL Profiler and Database engine tuning advisor to optimize queries and enhance the performance of Databases.
• Designed and created distributed reports in multiple formats such as Excel, PDF, XML, HTML and CSV using SQL Server 2005 Reporting Services (SSRS) .
• Created maintenance plans to process Cubes and to load data into warehouse.

Environment: MS SQL Server 2005/2008, SSIS, SSRS, T-SQL, Microsoft.NET, MS Office Access2003, Excel, C#,ASP.Net, VBScript, Erwin, Sybase ASE .