SUMMARY

• Over 7 years of IT experience with strong administration, design, development, and implementation experience on Microsoft SQL Server as SQL Server DBA.
• Extensive Experience in installation, upgrade and configuration of MS SQL Server databases.
• Hands on experience on SQL Server High Availability and Disaster Recovery features like Log shipping, Mirroring, Replication, clustering and Always ON.
• Extensive Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional Replications.
• Hands on experience on Backup Restore Jobs and Log shipping with SQL Server.
• Experience in Performance Tuning and Optimization (PTO), Client/Server Connectivity.
• Management of users and logins including creation/alteration, grant of system/DB roles and permissions on various database objects.
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
• Hands on experience on Failover Clustering and Always on Availability.
• Extensive experience in creating Tables, Views, Indexes, Stored Procedures, Cursors, Triggers and T - SQL queries.
• Utilize Java for application to access database data to present on the user interface.
• Extensive Experience in Business Intelligence (BI) Tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS).
• Experience in creating SSIS packages, Scheduling Jobs, Sending Alerts using Database Mail.
• Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS)
• Expertise in upgrading from MSSQL Server 2012 to MS SQL Server 2014.
• Experience in using DBCC Utilities to Check Database Consistency.
• Hands on experience on various SQL Server tools and IDE to work with database and BI based applications like SQL Server Management Studio (SSMS), Profiler, Business Intelligence Development Studio (BIDS) and Visual Studio 2013.
• Expertise in using Dynamic Management Views (DMV) to monitor the health of a server instance, diagnose problems, and tune performance.
• Experience with DDL, DML, and DQL in T-SQL.
• Experience in migration from Sybase to SQL server.
• Hands on experience on Microsoft Azure SQL Database and migration from on premises to Azure cloud service platform.
• Knowledge on installing and configuring Azure VM's on Cloud and VM ware.
• Knowledge on automation of SQL Server deployments and worked with DevOps team.
• Experience in using Joins and Sub Queries for the simplification of complex queries including more than one tables and defined relationship between multiple tables based on Primary key and Foreign Key constraints.
• Experience in Data ETL (Extraction, Transformation and Loading) using SSIS (SQL Server Integration Services) in SQL server with Import/Export Data, Bulk Insert.
• Knowledge on Sybase, Mainframes DB2, MySQL, Oracle, Mongo DB.
• Experience on Windows and Linux servers.
• Experience on Windows Administration like Windows Active Directory (AD) users and groups, IIS, SCCM, SCOM.
• Experience in functional testing ensuring all the functional requirements are tested.
• Extensive experience in Capacity planning, Performance Tuning, Disaster Recovery.
• Troubleshooting, backup and restore procedures. Creation and maintenance of Databases, creating Roles and managing user permissions.
• Hands on experience to deal critical issues and prepare Root Cause Analysis (RCA).
• Extensive Experience in database backup and recovery procedures which meet Recovery Point Objects (RPO) and test backup procedures which meet Recovery Time Objects (RTO).
• Hands on Experience on configuring Transparent Data Encryption (TDE) to protect sensitive data in databases.
• Experienced in Windows Cluster setup (WFCI & WC).
• Experience with Team Foundation Server (TFS) and GitHub.
• Experience in SQL Server Security by configuring security access to database users.
• Expertise in investigating and applying necessary SQL Server database patches and installing service packs.
• Documented disaster recovery plans and participated disaster recovery drills.
• Hands on experience on data modelling tools like Erwin and ER studio.
• Hands on Experience on SDLC Agile methodologies, SCRUM
• Experience in Working with testing teams; perform UAT testing with business users.
• Good working knowledge in .Net Framework C#, ASP.Net, ADO.Net, XML and Web Services.
• Good Knowledge on understanding Networking Concepts like LAN, firewalls, routers, switches, VLANS.

TECHNICAL SKILLS

Programming Languages: C,BS, SQL, TSQL, PL/SQL, XML, HTML, ASP.NET, Java, C#, Visual Studio 2010 Power Shell.

RDBMS: MS-SQL Server Access. DBMS MS-SQL Server 2008 Oracle11g, MS Access, DB2, Sybase.

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

OLAP Tools: SQL Server Analysis Services (SSAS)

Reporting Tools: SQL Server Reporting Services (SSRS) Crystal Reports.

DBA Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio (BIDS), Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Business Intelligence, Idera Tool set, SQL Lite speed, SQL Sentry.

Performance Tools: Erwin, Fog light, Idera, Spotlight, Tivoli, SCOM

Operating Systems: Windows Server Linux, Unix.

Backup tools: Idera, Light Speed, Native Backup, Power Shell, Red Gate.

PROFESSIONAL EXPERIENCE

Confidential, Washington, D.C

SQL Server DBA/Developer

Responsibilities:

• As a SQL Server DBA, Provided 24x7 missions critical production support of servers including production, test and development servers.
• Worked extensively on installation, upgrade and configuration of MS SQL Server 2012/2014/2016 and SQL Server Cluster.
• Done hot fixes and service packs for SQL Server 2014 based on patch management rule.
• Responsible for configuring security patches depending on the requirement.
• Experience on server and data migration from SQL Server 2008 to SQL Server 2014.
• Installed and configured Microsoft SQL Server 2016 on Windows servers.
• Implemented high availability solutions for mission critical SQL Server databases with clustering and Mirroring.
• Utilizing Java Server Faces, J2EE, and Oracle database as information.
• Implemented and monitored the replication between two sites, support and maintenance of MS SQL Server Transactional Replication.
• Worked as a developer in creating complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications
• Implemented Always on high availability solution in Pre-Production and Production environments
• Proactively monitored, determined and solved issues at SQL database/server levels with the help of Database Tuning Advisor and Profiler.
• Responsible for installing and configuring Azure SQL DB on Azure VM's and Azure SQL Data warehouse (DW) on Azure Cloud Platform.
• Worked on all phases of data warehouse development life cycle, from gathering requirement to testing implementation and support.
• Responsible for migration of SQL Server Database to Azure Cloud Service Platform.
• Analyzed business requirements and build logical and Physical data models that describe all the data and relationships between the data.
• Responsible for Physical Storage Structures and Index Design and Tuning.
• Restored and recovered databases to point in time for testing, pre-prod and production environments.
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• Used Dynamic Management Views (DMV) to monitor SQL Server health during runtime, troubleshoot the performance bottleneck/issues and proactively worked on to minimize the downtime
• Used SQL Profiler to find badly performing queries and deadlocks.
• Used third party tools like IDERA SQL Diagnostic Manager in taking the backups to optimize performance and restoring.
• Used Windows performance monitor and DB Artisan for troubleshooting, monitoring, optimization of SQL Server.
• Used SQL monitoring tool SQL Sentry for better performance of SQL Server.
• Worked on Performance tuning and optimization (PTO) of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
• Monitored database status including CPU, Memory, I/O, Space and dead lock using SQL Server Utilities.
• Installed and Configured SSAS environment on Windows Servers.
• Extensively worked with Database Developer's team to analyze and troubleshoot issues in ETL process.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Developed SSIS packages to export data from OLTP database to OLAP database.
• Implemented partitioning on several fact tables in datawarehouse using Clustered Column Store indexes.
• Scheduled the SSIS jobs using SQL Server agent for daily, weekly and monthly loads.
• Involved in loading the Warehouse databases and performing maintenance tasks on these databases.
• Involved in Prolaw updates including design of SQL triggers, and correcting database errors.
• Configured and generated reports using SSRS in Share point integration and native mode.
• Monitored regularly of the Time/ Data driven Subscription based SSRS reports (Monthly and Weekly) and SSIS external file transfers.
• Responsible for maintaining SQL Server security and granting access to users as per requirement
• Configured SQL Server security and access as per SOX and PCI standards.
• Responsible for configuring Transparent Data Encryption (TDE) to encrypt physical files of the database.
• Configured certificates and Database master key's (DMK) to protect data and physical media from malicious intent.
• Used Red gate tool for SQL diagnostics.
• Extensive testing done after migration to ensure the accuracy & timely processing of data.
• SSAS Administration including configuration, trouble shooting and monitoring processes.

Environment: MS SQL Server 2012/2014/2016 , Windows servers 2008/2012, IIS Web server, Visual Studio, Toad for SQL Server, Idera, Red gate, Microsoft CRM, SSIS, SSRS, SharePoint, Prolaw

Confidential, Midland, MI

SQL Server Developer/DBA

Responsibilities:

• Worked extensively on Data Warehouse setup on SQL Server 2012.
• Installed and configured SQL Server 2012, involved in data warehouse design using Kimball's methodology.
• Upgraded and migrated several instances from SQL Server 2008 to SQL Server 2012 and SharePoint instance from SQL Server 2008 R2 to SQL Server 2012.
• Developed SSIS packages to load data from different source systems in to data warehouse.
• Implemented Change data capture (CDC) to enable auditing of table changes and for incremental load to data warehouse (Slowly changing dimensions) using SSIS.
• Worked with business users, application developers for consolidation effort of several instances to VM Ware, resolved issues during consolidation.
• Worked in migration of Non - Clustered instances from physical environment to VM Ware environment.
• Worked extensively on two node Windows cluster setup on Windows Server and SQL Server as Active- Active Failover Cluster.
• Developed SQL scripts for administration task. Maintained SQL scripts, indexes, complex queries for data analysis and extraction.
• Developed PowerShell and T-SQL scripts for pre installation, post installation, pre migration and post migration checks for Data Center migration.
• Worked on enterprise solutions development with rapid SDLC Agile methodologies, SCRUM.
• Analyzed database growths for Capacity Planning, Normalized the data for efficient performance and also Partitioned data into multiple Files and File groups.
• Implemented SQL Server 2012 new features like Always On Availability Groups for high availability of multiple databases in place of database mirroring.
• Created complex DTS Packages for Data Migration and Transformation.
• Experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2012/2008R2.
• Experience in data migration from Excel to Excel through VB script.
• Administered several Oracle databases that supported the corporate data warehouse and payroll.
• Responsible for migration of databases from Oracle to SQL Server using SQL Server Migration Assistant (SSMA).
• Involved in Data Modeling, Normalization, developing Logical/Physical ER Diagram using Erwin and SQL Server Data Diagram.
• Worked on Oracle Golden gate for integration and data replication.
• Implemented contained databases and partially contained databases to reduce dependencies of application databases on instance and to ease portability of databases between different environments.
• Configured SQL Server 2008 R2 new feature Central management server to consolidate common jobs, remove duplicate jobs, to have multi-server jobs and maintenance plans.
• Used SQL profiler and Database Tuning Advisor in order to monitor and improve performance of SQL Server environment
• Configured master server to have a centralized maintenance for jobs and maintenance plans and to troubleshoot and run all the dependent jobs across the production servers.
• Performed online index rebuilds for critical tables and helped in reducing locks, improving query performance and made tables available during index rebuild operations.
• Implemented many stored procedures using DDL commands (Create, Alter, and Drop).
• Worked on Elite Enterprise application, table structure, and provided support to related financial applications and interfaces.
• Worked on billing experience utilizing Elite Enterprise.
• Evaluated the peak and no peak usage pattern of the application; effectively distributed database administration activities, such as full database backup and database defragmentation during no peak hours
• Used Solar winds for SQL Server monitoring and better performance.
• Used SQL Server error logs and event viewer to troubleshoot issues, Windows performance monitor to find resource usage, profiler and server side trace for tuning SQL queries, stored procedures.
• Performed Data Analysis for automating various Customers Reports utilizing SQL Analysis Services.
• Used Quest Lite Speed for backups and restore of very large databases.
• Used Red gate tool for SQL monitoring and diagnostics.
• Worked with developers to tune the SQL queries and improve the Performance.
• Configured security and access as per SOX standards.
• Experience in creating users and groups in Windows Active Directory (WAD)

Environment: MS SQL Server 2012/2008 R2, SSIS, SSRS, Microsoft.NET, MS Office Excel, C#, ASP.Net, Erwin, Visual Studio, Lite Speed, Red gate, Solar winds.

Confidential, NE

SQL Server Developer/DBA

Responsibilities:

• Created database objects like tables, views, indexes etc.
• Created and modified stored procedures, triggers, cursors and views.
• Actively involved as part of team for gathering and analyzing the needs of end user requirement and system specification.
• Responsible for High Availability features like Log shipping and mirroring on Production and Development Servers.
• Designed database standards as per HIPAA and PHI specifics.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008/2012 (using SSRS, T-SQL, scripts, stored procedures and views).
• Generated Monthly and quarterly Reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.
• Used Dynamic management views (DMV) for better performance and system health.
• Worked on SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Used Erwin to reverse engineer the existing database design in MS SQL Server 2005
• Worked on different kinds of transformations in SSIS as per the client's Requirement.
• Designed SSIS packages using integration services project in Visual Studio 2008.
• Extensively used various transformations in Control Flow tasks, Data Flow tasks using Visual Studio 2008.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Deployed the databases from old servers to new servers using Replication, based on the business goal.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and cubes in Analysis Services (SSAS) and finally to Reporting service.
• SSAS Administration including configuration, trouble shooting and monitoring processes.
• Created stored procedures and functions to support complex wealth management logic.
• Modified existing database by adding tables and relationship to existing data model.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity and provide additional application functionality.
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Created complex stored procedures for about SSIS which are used in the report to customize the report data and to make data analysis efficient.
• Created various dynamic reports by using formulas in Crystal Report 9 as part of enhancement.
• Moved logic from crystal reports into stored procedure to improve performance and keep crystal report as simple as possible by balancing workload between crystal report and SQL Server.
• Worked with BCP and DTS to load text files to SQL Server. Maintained the data, database backups and restoration, backup strategies, scheduled backups.
• Involved in complete backing up of Database and restored the database from Disaster Recovery.
• Configured SQL mail agent for sending automatic emails when a DTS process is failed or succeed using SSIS.
• Involved in testing, bug fixing and documentation for the project.

Environment: Microsoft SQL Server 2008/2012, Microsoft Excel, SQL Query Analyzer, Erwin, Visual Source Safe, Visual Studio, Crystal Reports 9 and SSRS, SSAS.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Planned and Successfully Installed SQL Server 2005, 2008 on the production and Development Servers.
• Developing the successful Backup strategies based on Recovery models.
• Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases and transaction log on production/development servers as per requirement.
• Involved in creating Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Involved in DTS/SSIS Package, DTS Import/Export for transferring data.
• Involved in implementation of replications like Transactional.
• Implementing Database maintenance plan for Database consistence & Integrity.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Ensured proper backup and recovery by maintaining DB2 image copies and recovery JCLs
• Efficiently carried out DBA responsibilities in planning DB2 version migration activities, in migration phases and in performing post migration tasks.
• Monitoring SQL server performance using profiler to find the performance and dead locks.
• Creating the Jobs using maintenance Plans for Full, Differential and transactional log backups.
• Maintaining and Monitoring Production, Pre-Production and Development database server environment.
• Having good knowledge on creation and scheduling of T-SQL jobs to run daily.
• Monitored database status including CPU, Memory, I/O, space and Dead Lock using SQL Server Utilities.

Environment: MS SQL Server 2005/2008, MS Access, MS Office, and Excel Spreadsheet, Visual Studio

Confidential

SQL Server Developer/DBA

Responsibilities:

• Installed and configured SQL Server 2008/2005 on Windows servers, applied service packs and security fix.
• Installed, configured and maintained MS SQL fail over clustering for critical production servers.
• Excellent experience configuring and maintaining all three types of replication like transactional snapshot and merge replication.
• Involved in upgrading from SQL Server 2005 to SQL Servers 2008 and test the application after the upgrade, make sure everything is working fine.
• Query Optimization handled by using extensive use of Index implementation and Index Tuning Wizard SQL Server 2005.
• Created Database, creating tables, views, indexes, stored procedures, triggers and constraints.
• Experienced with SSIS packages, SSRS and SSAS features in SQL Server 2005 servers.
• Used SSRS to write complex formulas and to query the database different to generate different types of ad-hoc reports.
• Configured and maintained High Availability feature like Log shipping architecture to provide backup server solution for 4 environments.
• Created the DTS packages to import the data from MS Access and Oracle server to SQL Servers.
• Created the standard documents for Disaster recovery testing and implemented them.
• Experienced with SQL Server 2008/2005 profiler, SQL Server management studio and Business intelligent development studio.
• Involved in restore operations to refresh the data from production to test servers.
• Involved in creating backup strategy production, test and development servers.
• Experience in setting up security features for MS SQL Servers and maintain the user access.

Environment: MS SQL Server 2005/2008, Windows servers, MS Access, Visual Studio MS Office, and Excel Spreadsheet.