SUMMARY

• Around 7+ years of experience as a SQL Server DBA and development performed with DBA duties all in enterprise environments
• Extensive working experience in various industries including Banking, Financial, Marketing services, and Healthcare industry.
• Experience in an operational environment providing support, involving coordination with release Management, Ticketing System and Change management.
• Extensively worked in OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server.
• Experience with Software Development Life Cycle (SDLC), Microsoft Operations Framework (MOF) and project management methodologies.
• Extensively worked with Middle vendors to troubleshoot issues, co - ordinate with developers at the time of release.
• Experience with SQL Server 2005/2008/ 2012/2014/2016 installation, administration and management of multiple instances/servers in highly transactional environments
• Worked with APP, DBA and Developers team on SSIS, Upgrade’s and Automation Procedures for various requirements.
• Experience with VLDB databases of size nearly 1TB on multiple instances.
• Experience with Migrations from SQL 2000/2005 to SQL Server 2008 and SQL 2012/2014/2016
• Familiar with SQL 2012 new features and hands on experience “Always On”
• Worked on Server Migrations (hardware), Data center migrations, Version upgrades.
• Worked on SQL 2008 features like data compression, backup compression etc
• Experience in backup and disaster recovery procedures like log shipping and high availability solutions like clustering, database mirroring
• Experience in Replication - Snapshot, Merge and Transactional.
• Hands-on working experience with analyzing query plans, query optimization, performance tuning, managing indexes and locks, troubleshooting deadlocks.
• Proactive monitoring with SQL Alerts, Jobs, and DBA related scripts & Reports
• Proficient with tools like BIDS, SQL Profiler, DMVs, IDERA Diagnostic Manager, Performance Dashboard.
• Excellent communication skills. Proactive, independent and easy-going.

TECHNICAL SKILLS

Languages: C, PowerShell, SQL, T-SQL

Databases: MSSQL SERVER 2012/2008/2005/2000/7.0 , ORACLE 9i/8.0/7.x

ETL/Data Modeling: DTS, PowerCenter 8.5.1, SSIS

OS: Windows 2008/2003/2000 Advanced Server, Server; Windows NT 4.0 Server/Workstation, IIS 6.0/5.0/4.0, Windows XP Pro/98 SE, Unix, VMWare

Hardware: HP/Compaq Proliant 8500, 6500, DL 380 G3/G2, DL 580 G3, DL 760 G3, DELL PowerEdge 2400, 4300, 6300, Gateway Servers.

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, Maryland

SQL DBA

Responsibilities:

• Providing thought-leadership around solution / industry framework etc.
• Partnered with developers to automate manual processes, saving time and money while decreasing errors. Credited as a primary driving force behind a 5% increase in margins this fiscal year.
• Analyze and provides recommendation on application logic/interfaces to improve database performance, capacity, and availability.
• Identify opportunities to optimize application data models for performance, manageability, scalability and availability.
• Perform database administration activities such as storage management, backup and recovery
• Analyze and resolves critical and complex database issues; Ensures successful, daily backups and guaranteed recoverability.
• Identify tasks to be automated developing scripts and supporting documentation
• Migrate Database Servers from SQL, 2012 and 2014.
• Maintain availability and integrity of databases through multiple access schemes; facilitate sharing of common data by overseeing proper key and index management and data dictionary maintenance.
• Contributes improvements of the databases/database environment.
• Providing technical direction for the development, design, and systems integration across multiple projects from definition phase through implementation.
• Leveraging expertise in SSIS Architectural Frameworks and guide the development team by demonstrating PoCs / components
• Guiding in planning technical validations and testing strategy on complex solutions
• Providing expert guidance in leveraging re-usable components and help manage the solution risk
• Installing SQL Servers and configuring them as per applications needs

Environment: Windows 2003 Server, Windows 2008 Server R2, MS Visual Studio 2010, C#, JavaScript, VMware, MS SQL Server 20

Confidential, Connecticut

SQL DBA / Application Support

Responsibilities:

• Posting the bugs on the Enterprise Backlog
• Involved in designing of Conceptual Logical Model and Physical Model
• Worked on PeopleSoft Change Management Systems and coordinated with developers at the time of releases on “Financial Significant” Apps
• Fixing associated bugs reported by Testers.
• Preparing documentation of all the tasks performed.
• Working with different teams on Versioning databases in all Prod Environments
• Replicated ETL environment into Test/QA/SIT with minimum documentation.
• Used tools like SQL LightSpeed and SQL Server backup v9 and NetBackup client for backing up databases.
• Worked on Visual Studios 2010/2012 to build databases to Upgrade products and check in the changes to TFS Server.
• Release Management and Knowledge on tools
• Had excellent knowledge on handling Release process and Release Management
• Extensively worked with DBA, Development and Architect teams to define the release process as suits the organization and environment
• Good knowledge on Red gate tools of Schema Compare, Migration Script Creations, Deployment Manager and SQL Data Generator
• Installed and configured MS SQL Server 2005. Edited the server registration properties, Created Logins. Managed the object level permissions and security issues of the server.
• Created database objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, User defined data types and Functions in SQL Server 2005/2008
• Performance: Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve queries.
• Experience in setting up Always On in SQL 2012 and Migration from SQL 2008 r2 to SQL 2012
• Deployed SSIS packages and Scheduled Jobs.
• Created temporary tables and table variables while creating complex queries in SQL Server 2005/2008.
• Defined Indexes, Views, Constraints and Triggers to implement business rules

Environment: Windows 2003 Server R2, MS Visual Studio 2010/2012, Microsoft Team Foundation Server 2010, C#, JavaScript, VMware, MS SQL Server 20

Confidential

SQL DBA / Business Analyst

Responsibilities:

• Created tables, views, indexes and user defined functions.
• Installation, Administration, Configuration of SQL Server 2000, SQL Server 2005 and SQL Server 2008
• Optimized query performance by creating indexes.
• Involved in Data modeling to develop the database design using ERwin
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server
• Worked on and had good knowledge on Windows NT Administration.
• Had good knowledge on Release management and Ticketing System
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Involved in designing of Conceptual Logical Model and Physical Model.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse
• Wrote Transact SQL utilities to generate table insert and update statements.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances
• Created joins and sub-queries for complex queries involving multiple tables.
• Used DDL and DML commands for writing triggers, stored procedures, and data manipulation.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Created Indexes for fast retrieval of the data and involved in Performance tuning.

Environment: SQL Server 2000/2005/2008 , MS Access, Windows 2003 Advanced Server, T-SQL SSIS and SSRS, Storage area network(SAN)