SUMMARY

• 9+ years of IT experience in Database Design, Data Modeling, Data and Database Security, Requirements Analysis, Application Development, Testing, Implementation and Deployments using SQL Server 2014/2 .
• Experience with Multi - Servers and Multi-Terabyte Databases design for Very Large Databases
• Strong experience in Business Intelligence (BI) using Visual Studio 2008/2005.
• Administered DB2 Z/OS for v 9.x/8.x/7.x/6.x on IBM mainframe and AIX DB2 environments.
• Experience in primary data analysis, mapping and migration from Oracle to SQL server
• Hands on experience and outstanding knowledge of high availability SQL Server solutions, including replication and SQL Server Alwayson, clustering, log shipping and Mirroring.
• Created, Built and deployed successfully dynamic SSIS packages into SQL Server 2008/2005 databases and scheduled them according to requirements.
• Extracted, Transformed and Loaded data in Data warehousing using SSIS packages.
• Involved in migrating DTS packages from SQL Server 2000 to SSIS packages in SQL Server 2008/2005 database.
• Experience in Migration of Data from Excel, Flat file using DTS, SSIS and other ETL Tools.
• Experience in working with Reporting tools like MS SQL Server Reporting service (SSRS), Report Builder and BIDS
• Rendered reports in CSV, PDF, XML and Delivered reports by file share and E-mail according to schedule.
• Experience on BizTalk, SSRS, SSIS, SharePoint.
• Experience in Database Design activities including Data Files and File group organization, Capacity Planning, Data Partitioning and Data Normalization.
• Resolved issues with Indexes, Blocking and locking issues to remove the performance bottlenecks.
• Database design & administration experience onSQL Azure, MS-SQL Server 7/2000/2005,
• Proficiency and Expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Rebuild online index and worked with Dynamic Management Views (DMV) for improving query performance.
• Experience on migrating Sybase ASE old version(11.9/12.x) database into Oracle and MS SQL serverSQL Server 2012 migration from SQL Server .
• Thorough understating of Windows Clustering (Failover) Concepts and Experienced in Configuring/Optimizing Software Based SAN (Iscsi) using StarWind Software for building POC SQL Server Clusters.
• Experience in Change Data Capture (CDC), Change Tracking (CT) in SQL server 2008.
• Experience in Creating complex Views, Stores Procedures, DDL/DML Triggers and User-Defined Functions to implement Business Logic and Data Protection.
• Good hands-on with creating Partitioned Tables and Partitioned Views.
• Creating and managing schema objects such as Tables, Views, Indexes, Stored Procedures and User-Defined Functions depending on the Technical Requirements.
• Experience in migration of data using BCP Utility, Bulk Insert command, SSIS and DTS Packages, Import/Export Wizard and Copy Database Wizard.
• Expert in Query Tuning and activities including Updating Statistics, Re-building and Re-organizing Indexes.
• Monitoring and optimizing the performance of the Queries and Indexes using SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor, DBCC commands and Dynamic Management Views.
• Solid experience with third Party tools for supporting SQL Server Databases like Quest (now DELL), Red Gate, Idera, Confio, ApexSQL and SQL Sentry.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, VB.Net, HTML, C

Services: Database Engine, SSIS, SSRS(Visual Studio 2008, 2005)

RDBMS: MS SQL Server 2014, 2012, 2008, 2005, 2000, 7.0MS Access databases,DB2,Oracle 10 g,11g, Sybase ASE,DB2

Reporting Tools: BIDS, Report Builder 2.0, Report Builder 3.0

Modeling Tools: Microsoft Visio, SQL Diagrams, ERWIN 4.1, SQL Server Enterprise Manager SPUFI,QMF

Operating Systems: Windows 2008 R2/2003/2000 Server (64/32 Bit), Windows 2000 Professional, Windows NT 4.0/3.5.

Other Tools: DTA,Perl,SQL Profiler, DTS XCHANGE, Citrix, Diagnostic Manager, SQL Lite speed, RMAN, Precise, Spotlight, C A Harvest, TSM, Quest Lite speed, Quest Spotlight enterprise on SQL Server

PROFESSIONAL EXPERIENCE

Confidential

MS SQL Server DBA

Responsibilities:

• Responsible for Confidential -Broadridge conversion for setting up New QA environment (Around 100 + new servers) to match Production and tasks like Data masking, Data Refresh, QA testing support and Deploying changes and break fixes.
• To architect/scale out Database Servers (standalone and clusters) for clients based on their applications.
• Finding out any missing standards and Providing Best practices for maintaining SQL Servers efficiently. Successfully implemented several new standards for the Client, with tremendous proven improvement as part of Sql Security Vulnerability Remediation.
• Responsible for handling the Non-Prod/Prod Ticketsand to provide regular day-to-day DBA support for all of our Application teams which includes both Confidential Shared and dedicated SQL Servers, comprising both Standalone and Failover Clusters.
• Built/Developed a SQL Server Post Install Setup solution for Confidential Business Solutions, which basically automates all the required standards dynamically based on the User input and sends an email notification..
• To Lead, mentor and/or provide guidance to less experienced database analysts, where applicable, including guidance for troubleshooting escalated issues.
• For SQL Server 2012 and 2014, to architect AlwaysON Solutions, design replication topologies and supporting Log shipping on legacy systems.
• Working with Internal/External Auditors on Audit Requirements/Regulations and making sure that we are SOX Compliant.
• Working closely with Microsoft BI Team for managing/administering/troubleshooting SSIS/SSRS/SSAS.
• Recommended and Implemented new HA/DR strategies wherever needed for the client.
• Installed, managed and administrated the MS SQL Server 2014/12/08/05 Production and Non Production Servers
• Performed installation of SQL Enterprise bit version on Windows 2003, 2008 servers and VM ware servers on Enterprise systems of Clustered and standalone servers in enterprise datacenters. Patch applications.
• Handled 4-node Node Always-on Environment
• Involved Upgrade and Migration of SQL Server 2005/2008 in placed, side by side to MS SQL Server 2012.
• Working with Change Control Team, for proper roll out of any change to Production in accordance with SDLC.
• Working on day to day Service requests/incidents from application teams, supporting their deployment activities and being On-call DBA as needed.

Confidential, Detroit, MI

MS SQL Server DBA

Responsibilities:

• Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition..
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Expert in implementing the snapshot isolation and DDL triggers.
• Experience with 10 + Tera Byte databases.
• 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.
• Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters (HP servers in enterprise Data Centers).
• Involved in analysis, database designing, coding and testing.
• Optimized the performance of Queries and Store Procedures with modification in T-SQL statements, by removing unnecessary columns, by eliminating redundant and inconsistent data, by renormalizing tables, and created indexes wherever necessary.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Used SQL Server Profiler to monitor and record database activities of particular users and applications
• Managing the VERITAS net backups.
• Hands on experience in Setup and Troubleshooting Log shipping and mirroring.
• Installing SQL Server with minimum access privileges service account to improve security and to attain high ratings in SOC audits.
• Comprehensive experience utilizing VMware technologies in the deployment of mission critical SQL Server environments.
• Experienced in designing and deploying HA and DR solutions using VMware technologies.

Environment: SQL Server 2008/2012/2014 Enterprise, Windows Enterprise Server 2012, SQL LiteSpeed 4.5, MSE, ME Change Request, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler

Confidential, Manassas, VA

SQL Server DBA

Responsibilities:

• High Availability Disaster Recovery during SQL2014migration.
• Migration of 200+Sql Servers from Physical to Virtual migration as a part of Sql server Licensing project.
• P2V migration of 2005 and and 2012 Migrations
• Production supporting DBA activities in huge OLTP environments.
• Query tuning queries based on Hich CPU, Memory and Logical reads and writes.
• Analyzing and designing and implementing different types of Replication Models.
• Spreading huge tables to different file groups to achieve maximum performance.
• Writing TSQL code and complex stored procedures for different tasks. Tuning the code written by team members to achieve optimum performance.
• Setting up DR solutions using Log shipping, Mirroring, Always On (2012) in windows clustering environments for High Availability.
• Experienced in designing and deploying HA and DR solutions using VMware technologies.
• Comprehensive experience utilizingVMwaretechnologies in the deployment of mission critical SQL Server environments.
• Audited and tuned production MySQL servers
• MySQL multi-master replication setup
• Experience in managing more than 1000 Database servers
• Setting up monitoring alerts and dashboards in addition using of SQL built-in dashboards.
• Discussion with peers about performance issues, SQL Internals about log shipping, DB mirroring, replication etc.,
• MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Database creation, restoration, recovery, User/Schema Creation and maintenance Space Management.
• Monitoring and Troubleshooting SQLServer using Windows System Monitor, creating an Alert in Windows System Monitor, creating a SQL server Performance Alerts.
• Data migration (import & export - BCP) from Text to SQL server.
• Setting up High availability always on future on new 2012 servers.
• Good understanding and experience in SQL Server 2008 features like Change Data Capture (CDC), Transparent Data Encryption (TDE) and Policy based Management.
• Prepared and documented Backup & Restore Plans and manage data import and export form multi-agency interfaces
• Audited and tuned production MySQL servers
• Supported Application Development team with any database issues, updates or new releases. Support included deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc

Environment: SQL Server 2014/2012/2008 , SSIS, SSRS, Visual studio 2008, MS Visio 2007, XML, VB.Net,Report Builder 3, Oracle 11gR2, BizTalk, SSRS, SSIS, Sybase,DB2,MYSql Vmware.

Confidential, Edison NJ

SQL Server DBA

Responsibilities:

• Providing On-Call Support for all SQL Server based Applications on rotation basis, comprising 162 SQL Server Instances.
• Responsible for coordinating with application teams for upgrading their entire existing SQL Server 2000/2005 Instances and MS Access Databases to SQL Server 2008R2.
• Analyzing and designing and implementing different types of Replication Models.
• Configuring 3rd Party Tools like Quest Foglight and Oracle Client Tools on SQL Servers and Working with Oracle DBA team for TNS Issues or any other Oracle Issues for our Linked Servers.
• Spreading huge tables to different file groups to achieve maximum performance.
• Writing TSQL code and complex stored procedures for different tasks. Tuning the code written by team members to achieve optimum performance.
• Setting up DR solutions using Log shipping, Mirroring, Always On (2012) in windows clustering environments for High Availability.
• Setting up monitoring alerts and dashboards in addition using of SQL built-in dashboards.
• Discussion with peers about performance issues, SQL Internals about log shipping, DB mirroring, replication etc.,
• MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Database creation, restoration, recovery, User/Schema Creation and maintenance Space Management.
• Monitoring and Troubleshooting SQLServer using Windows System Monitor, creating an Alert in Windows System Monitor, creating a SQL server Performance Alerts.
• Maintaining and Automating SQLServer like, Configuring Database Mail, creating an Operators, Creating Jobs, Alerts, Database Maintenance plans.
• Took the lead in many occasions to Analyze/Fix Performance Issues of Applications.
• To Lead, mentor and/or provide guidance to less experienced database analysts, where applicable, including guidance for troubleshooting escalated issues
• Designed SQL SSIS Packages in Business Intelligence Development
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Created new databases, involving importing and exporting: installing and configured database software for Oracle Application development environment. worked on migratingSybaseASE old version(11.9/12.x) database into Oracle and MS SQL server

Environment: SQL Server 2012/2008, SSIS, SSRS, Visual studio 2008, MS Visio 2007, XML, VB.NetReport Builder 3, Oracle 11gR2, BizTalk, SSRS, SSIS, Sybase.

Confidential, NY

SQL Server DBA

Responsibilities:

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
• Performed data migration from SQL Server 2005 to SQL Server 2008.
• Implemented Functions, views, triggers and stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Created SQL scripts for tuning and scheduling.
• Performed data conversion from flat file into a normalized database structure.
• Created Triggers to enforce data and referential integrity.
• Installing of report builder 3 and Deploying the Reports
• Create new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2008.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Responsible for creating the reports basing on the requirements using SSRS 2008.
• Data migration (import & export - BCP) from Text to SQL server. worked on migratingDb2 database into MS SQL server
• Good understanding and experience in SQL Server 2008 features like Change Data Capture (CDC), Transparent Data Encryption (TDE) and Policy based Management.
• Studio (BIDS), to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2008, 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all; Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks in Visual Studio 2008.
• Prepared and documented Backup & Restore Plans.
• Created clustered and non-clustered indexes to improve the performance of queries with by understanding the Actual execution plan. Eliminated key-lookups, table scan and converted index scan to index seek
• Backing up master & system databases and restoring them when necessary and automated backup processes using SQL Server jobs.
• Supported Application Development team with any database issues, updates or new releases. Support included deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc.
• Experience with BMC Patrol, DBArtisan, Quest Fpass. .
• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
• Created Daily System Health Checks Reports for Space, CPU, Memory, Table Statistics, Indexes.
• Experience with Oracle11g, Oracle RAC, Oracle Grid, RMAN.

Environment: Windows 2003 Server, SQL Server 2005/2012, SQL Server 2000,T-SQL, PL/SQL, Erwin 4.1, JavaScript, MS IIS Server 5.0, SOAP, Perl, XML, Oracle8i/ Oracle11g.