SUMMARY

• Approx 9.8 years of IT experience in Database Administration, Design Development and Support of MS SQL Server 2014/2012/2008 R2/2005 in Production, Test and Development Environments.
• Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2005/ 2008/2012/2014.
• Experience in Disaster Recovery Planning, Execution and Testing at remote side.
• Worked on data modeling, database designing, space management and capacity planning for database systems.
• Develop database tables and Stored Procedures. Ensure data quality and integrity in databases.
• Create complex functions, scripts, stored procedures and triggers to support application development.
• Evaluate existing database and recommend improvements for performance efficiency. Develop best practices for database design and development activities.
• Setting Up the AlwaysOn Availability Group in SQL Server 2012/2014 Failover Cluster. Worked in setting up/install Windows Failover Clustering(WCF) as well.
• Worked on creating three node failover cluster in SQL server 2012 and two node failover cluster in SQL Server 2014.
• Experience in using SQL Server Tools like DTS, Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler, SQL Query Stress, Activity Monitor and SQL Query Analyzer.
• Performed Performance tuning using SQL Profiler and Database tuning advisor.
• Migration experience from MS SQL Server 2005 to MS SQL Server 2008 and MS SQL Server 2008 R2 to MS SQL Server 2012.
• Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them).
• Master in performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration and synchronization.
• Extensive use of DTS/SSIS in SQL Server, Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, Managing server and clients.
• Experience in implementing high availability using Log shipping, and knowledge of DB mirroring in SQL Server 2005/2008/2012 .
• Extensive experience with IIS (Internet Information Services) 5.0/6.0/7.0.
• Solid experience on high availability SQL Server solutions, including Replication Models (Snapshot/Transactional) and SQL Server clustering (Active - Active, Active-Passive).
• Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2005/ 2008/2012/2014.
• Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS Packages to SSIS, Package Migration Wizard, and Storage Management.
• Experience in using SSIS (SQL Server Integration Services) for data extraction, transformation and loading across different databases like Oracle, MS Access and flat files using tools like Import and Export Wizard, Package Installation and SSIS Package Designer.
• Experience in designing/generating/using/deploying Visual Studio 2008/2012/2014 Business Intelligence Reports, SQL Server 2008/2012/2014 Reporting Services (SSRS), Crystal Reports.
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
• Sound Experience and understanding of SSAS, OLAP cube and Architecture. Worked in developing CUBES, dimensions, measures.
• Expert in creating Star schema cubes usingSSAS.

TECHNICAL SKILLS

Operating Systems: Windows Server 2003, Windows 2008 R2 Server, Windows Server 2012, Advanced Server, Windows 98/XP/Professional

Database Tools: Database tuning Advisor(DBTA), Activity Monitor, Trace Flags, Job Activity Monitor, DMV, SQL Query Stress, SQL Profiler, DTS, Management Studio/Enterprise Manager, Query Analyzer, Performance Monitor, Microsoft Upgrade Advisory Tool, Microsoft Assessment and Planning tool kit(MAP Toolkit)

Web Technologies: XML, HTML, VBScript

GUI Tools: Visual Studio 2005/2010/2012

Languages: VB 6.0, VB.Net, T-SQL, Perl

Web Server: Internet Information Server

Databases: SQL Server 2014/2012/2008 R2/2005, MS Access

Version Tool: SVN, TFS

OLAP Tools: SQL Server Reporting Server 2014/2012/2008, SSRS, SSIS (as ETL), SSAS

PROFESSIONAL EXPERIENCE

Confidential, Sugarland, TX

Lead Database Administrator - SQL Server

Responsibilities:

• Managed security on Production and Development environments.
• Monitored the complete environment for resource utilizations and to avoid any bottlenecks.
• Worked on Setting Up the AlwaysOn Availability Group in SQL Server 2012/2014 Failover Cluster.
• Develop database tables and Stored Procedures. Ensure data quality and integrity in databases.
• Creating and maintaining various databases on Production and development environments using SQL Server 2008 R 2/2012/2014.
• Created jobs to import/ export data obtained from various States to update the GIS servers.
• Installed and configured SQL Server Reporting Services.
• Installed necessary Service Packs for SQL server 2005/2008R 2/2012/2014.
• Installed SQL server 2005, 2008,2012 and 2014 on a test environment to be the future production environment.
• Upgraded legacy 2005 databases to SQL server 2008 R2/2012/2014 per requirement.
• Involved in Database Backup and recovery.
• Automated database backup and restore through Team Foundation Server(TFS)
• Implemented high availability on the various servers using replication/mirroring.
• Tuned databases for better performance.
• Created and maintained various logins and managed security based on the required access.
• Implemented and tested the point in time recovery of the production databases.
• Involved in migrating share point from one server to the other.
• Created various jobs to monitor resources on various servers and to mail the necessary information when threshold was reached.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Loaded the data into another data sources (SQL Server) using SSIS.
• Created various SSIS packages based upon the requirement.
• Created various reports using SSRS.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine tuning Stored Procedures).
• Contacted various users in gathering the requirements and documented the necessary changes.
• Analyzed various backup compression tools available and made the recommendations.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for theSSAScubes.
• Created necessary templates for various requirements gathering and documentation.

Environment: Windows 2005/2008 R2/2012, MS SQL Server 2008 R2/2012/2014, SSRS, DTS, SSIS, SSAS, BCP SQL Server Profiler, SQL Query Stress, Activity Monitor, Database Tuning Advisor(DBTA), VB.NET, T-SQL, IIS 6.0/7.0, RightAngle(S10/S11.6/S12/S14), TFS 2010/2012

Confidential, Houston TX

Lead Database Administrator - SQL Server

Responsibilities:

• Installed and maintained MS SQL Server 2008 on Windows 2008 Server.
• Worked on setting Up the AlwaysOn Availability Group in SQL Server 2012/2014 Failover Cluster. Installed Windows Failover Clustering(WCF) as well in windows 2012.
• Worked on creating three node failover cluster in SQL server 2012 and two node failover cluster in SQL Server 2014.
• Create complex functions, scripts, stored procedures and triggers to support application development.
• Installation and configuration of SQL Server 2005,2008,2012 and 2014 databases
• Upgraded SQL Server 2008 to SQL 2012 server for high volume processing databases and support third Party application RightAngle upgraded version(S14.1).
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Configuring, tuning and optimizing SQL Server 2008/2012/2014.
• Administrator tasks like managing users, roles and permissions.
• Involved in complete database design including conceptual, logical and physical models.
• Performance testing on stored procedures, indexes, and triggers.
• Creating DTS Packages for data import/export, scrubbing and scheduled jobs for backups for SQL and Oracle Databases.
• Modeling and architecture of the SQL Server 2008/2012/2014 database.
• Creation of reports like Reports by Period, Demographic reports and Comparative Reports.
• Creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Maintained high availability of databases using Database Mirroring and Log Shipping.
• Used third party tool, Lite Speed to speed up backup operations.
• Created Complex reports using SS Reporting services.
• Created and maintained logical/physical data structures.
• Creating views and stored procedures and optimizing them as required by front-end developers for easier implementation on web pages.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Involved in creating calculated members, named set, advanced KPI’S for theSSAScubes.
• Technical Analysis, Code Review, Implementation, 24 x 7 production support

Environment: Windows 2008 R2, MS SQL Server 2005/2008 R2/2012, SSRS, DTS, SSIS, SSAS, BCP SQL Server Profiler, VB.NET, T-SQL, IIS 6.0/7.0, RightAngle(S10/S11.6/S12/S14), Database tuning Advisor(DBTA), Activity Monitor, Trace Flags, Job Activity Monitor, DMV, SQL Query Stress

Confidential, Houston, TX

Lead Database Administrator - SQL Server

Responsibilities:

• Installed SQL Server service packs based on the errors and flaws that are found in the application
• Support development, QA and other pre-production database environments of Microsoft SQL Server 2008/2012 for current on-going projects and new initiatives.
• All critical SQL Server services
• SQL AlwaysON failover cluster
• Perform database restore and recovery as needed
• Supported 24 X 7 Production environment
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Complete Internet programming and development, including web site design, project management, HTML, Cold Fusion programming (SQL/Database integration), JavaScript.
• Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application.
• Managed the use of disk space, memory and connections.
• Performed DBCC utilities and fixed data corruption in application databases.
• Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.
• Created and managed schema objects such as tables, views, indexes, procedures, and triggers & maintained Referential Integrity.
• Performed Server & Application fine-tuning & troubleshooting. Monitored MS SQL Server performance and network issues.
• Helped Development Team in deploying and testing the application, which uses SQL Server as a database.
• Used text files as Data providers, thereby worked with multiple data providers
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
• Implemented different types of Replication Models like Snapshot and Transactional.
• Dropped and recreated the indexes on tables for performance improvements. Used Index tuning wizard for tuning of indexes.
• Controlled user access rights, and managed data security.
• Traced long running queries and deadlocks using SQL Profiler.

Environment: MS SQL Server 2005/2008/2012, Windows 2005/2008/2012 Server, Visual Studio.Net, T-SQL, MS Access, SQL Profiler, System/Performance Monitor, DTS, Database tuning Advisor(DBTA), Activity Monitor, Trace Flags, Job Activity Monitor, DMV, SQL Query Stress

Confidential

Database Administrator - SQL Server

Responsibilities:

• Interacted with various customers on day to day basis and analyzed their SQL server environments.
• Analyzed various SQL server environments and suggested best practices for better performance.
• Administered the space usage of the various databases for various applications.
• Automated consistency checks of the database (DBCC) for SQL Server.
• Analyzed the complete environment for resource utilizations and suggested upgrades to increase I/O and avoid bottlenecks.
• Installed and configured SQL Server Reporting Services.
• Suggested various architectures that can be implemented after upgrading from older versions of SQL server to SQL server 2005.
• Proposed various high availability options to maintain the high availability of SQL server on various environments.
• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.
• Created various automated processes to update the Reporting services databases on a regular basis.
• Suggested and implemented various SQL Server Reporting services environments.
• Upgraded SQL server 2005 boxes to SQL server 2008 and acted as the point of contact for all developers.
• Upgraded SQL server 2005 to SQL server 2008 on a Clustered environment.
• Designed and developed data warehouse data stores, and analyzed business requirements, developed target-source data mappings and delivering ETL processes for end-user OLAP and reporting initiatives (Used report services as and OLAP client schedule reporting tool ).
• Primarily responsible for developing database solutions that provide the business with the information needed to make daily operating and strategic decisions. Perform data modeling activities, application performance tuning and code reviews.
• Implemented various high availability options for SQL server 2005/2008 including replication.
• Tested point in time recovery of the production 2008 databases using the traditional backup/restore technique.
• Setup replication for high availability.
• Installed SQL server and implemented resource utilization on the server.
• Converted many DTS packages to SSIS packages during the up gradation of the servers.
• Involved in performance tuning and query optimization.
• Fixed and rebuilt many SSIS packages during the migration.
• Analyzed many databases in various environments for performance issues.
• Monitored network for bottlenecks.
• Involved in tuning various reports generated using SSRS.
• Documented the various observations made and suggestions on various environments.

Environment: Windows 2005/2008, MS SQL Server 2005/2008, SSRS, DTS, SSIS, SSAS, VB 6, SQL Server Profiler, T-SQL, SQL Loader, Database engine tuning Advisor.

Confidential

Database Administrator - SQL Server

Responsibilities:

• Performed DBCC utilities and fixed data corruption in application databases.
• Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.
• Created and managed schema objects such as tables, views, indexes, procedures, and triggers & maintained Referential Integrity.
• Performed Server & Application fine-tuning & troubleshooting. Monitored MS SQL Server performance and network issues.
• Helped Development Team in deploying and testing the application, which uses SQL Server as a database.
• Enhancement of all the PBCOMM websites used by users with better look and feel.
• Separate website was also provided to user to load file on their own in case of any failure. This was termed as User Driven Processing (UDP).
• Another website was available for user to check processing logs of any file for any broker/client set up for any particular day. This was termed as Incoming Processing Log website(IPL).
• Website was also there for users in case they want to see files from broker coming in for any client and what all maps were applied on them. This was termed as Dynamic Page.
• Another website was provided to check all reports that were made available from broker. This was termed as Daily Reports Page (DRP).
• Likewise, there were more than 20 websites designed for reconciliation purpose.
• Implemented Configuration Management, Change Management policies and procedures.
• Build, configured and support Application team environments.
• Improved logging and created log reporting system.
• Support Lead developers with Configuration Management issues.
• Worked for Creating the Software Configuration Management Plan.

Environment: Shell scripting, Perl, SQL Server 2005, Unix, HTML, CGI Programming, Rational Clear Quest and Rational Clear Case.