SUMMARY

• Over 8 years of experience ranging software development, testing, assurance, and implementation and working in complex engagements.
• Coordinated all phases of software testing lifecycle, from requirements analysis through test planning, defect tracking, test case development and test reporting.
• Leverage strong communication and interpersonal skills to cultivate strong working relationships with clients, vendors and offshore partners.
• Worked independent and as a team with strong critical thinking, timemanagement and proven handling of responsibilities and projects.
• Solid 6+ years in depth experience in MS SQL Server database development and administration in enterprise environment including server installation, configuration, upgrade, maintenance, performance tuning, optimization, backup/restore, recovery, migration, monitoring, security planning and trouble - shooting.
• Develop and implement policies and standards for preserving the integrity and security of data.
• Good understanding in database and data warehousing concepts (OLTP & OLAP).
• Transformed data from one server to other servers using tools like SQL Server Integration Services (SSIS) (2008 R2).
• Running and scheduling SSIS packages, validating data using SSIS.
• Experience in Optimizing Code and Improving Efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks and DBCC Commands.
• Extensive experience in Capacity planning, Performance Tuning, Disaster Recovery, Troubleshooting, backup and restore procedures
• Experience in logical, physical, and dimensional data modeling, data mapping, and data normalization.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report formatting, Report distribution, Report delivery and Report security.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Migrated DTS packages into SSIS packages using upgrade advisor tool.
• Database Monitoring tools like profiler, performance monitor and Event viewer.
• Good understanding in SQL user logins, database user accounts, server roles, database roles and its permissions.
• Experience in integrating the SSRS reports into web applications using Report viewer control, URL methods and creating data driven subscriptions to different users using Report Manager.
• Good T-SQL Programming skills. Experience in query optimization & performance tuning.
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Worked on administration tasks such as data loading, batch jobs, data unloading, backup & recovery, scheduling the backups, user and application table management, creating Databases/File groups/Files/Transaction logs.
• Expert experience in handling huge volume of data and transforming and cleansing of data and raw data.
• Strongly acquainted with RDBMS
• Assisted web service for BI

TECHNICAL SKILLS

Relational Databases: SQL Server 2012/2008 R / 7.0, MS-Access 2000/2003/2007 , Oracle 9i & 10g, My SQL4/5.

Database Tools: SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, SSAS, SSRS, DTS, BCP, ODBC,SQL OLEDB, DBCC, ADO, ADO.NET, Business Intelligence Studio, Crystal Reports.

Languages: C, C++, C#, JAVA, VB.NET, ASP.NET, XML, PHP, UNIX Shell Scripts, T-SQL.

Operating Systems: Windows 2003/2008/2012 server, Win ME/NT/XP, UNIX.

Web Servers: IIS 5.0/6.0, Apache, Tomcat.

Architecture: Relational DBMS, Client-Server Architecture, Clustering, Replication, OLAP, OLTP,DB2.

ETL: SSIS, DTS, Informatica, Data Stage.

Other Tools: Erwin 4.0/3.5, Microsoft Visual Studio 2003/2005, Service Center, MS Visual SourceSafe, Source Control, MS Visio, Windows System Monitor, Redgate, sql compare, lite speed, Windows Server, Active Directory, Virtualization.

PROFESSIONAL EXPERIENCE

Confidential

Sr SQL DBA

Responsibilities:

• Assess current state of databases.
• Data Migration from MS SQL Gupta to SQL Server 2008 using ETL.
• Performed Data Mining, Reporting, migration and Database design.
• Ensured that the system is standardized
• Wrote Stored Procedures and database structure for New applications
• Worked on Relationship Structure and corrupt data.

Confidential, Dallas, TX

Sr. SQL DBA

Responsibilities:

• Installation of MS SQL 2008 R2 servers on production, Test and Development boxes.
• Developed ETL solutions using SQL Server Integration Services (SSIS) to import data based on requirements for easy/less maintenance and easy upgrade.
• Employed condition based notifications to let the user know the status of the Agent jobs.
• Developed complex SSIS packages using proper control flow tasks and data flow transformations as per business requirements.
• Migrated data from EXCEL and Flat files using SSIS packages to load data to the relational database in SQL Server 2008R2 supporting BI solutions.
• Implemented Jaro-Winkler distance algorithm to calculate the similarity between strings in Sql server.
• Developed custom vb scripting for use in building custom functionality in job alerts.
• Developed dynamic SQL and dynamic store procedures, views, indexes, CTEs, cursors for business needs.
• Developed test scripts and environment of the developed SSIS solutions and the loaded data.
• Developed complex SQL scripts based on the business requirements in SQL Server databases.
• Developed physical model database scripts based on logical model.
• Implemented Disaster Recovery plans using Database Mirroring and Log Shipping.
• Documented disaster recovery plans and participated in disaster recovery drills.
• Controlling day to day activities of Production database and troubleshooting the issues.
• Expertise in using TOAD, SQL Plus, SQL Server Management Studio (SSMS) to access various databases.
• Researched and implemented SQL Server Auditing 2008 on SQL Servers for Auditing needs.
• Involved in requirement gathering, technical documentation Phases, supporting testing.
• Created and scheduled jobs using SQL Server Agent.
• Created ETL jobs to load and clean gigabytes of data and also handled partitioning of the tables in ETL as a part of performance tuning while handling huge volume of data.
• Provided production support and resolved production tickets.
• Worked on Data warehouse loading from SQL server databases.
• Worked on deploying application level changes for important enhancement decisions.
• Architected and worked on implementing Log shipping on multiple servers.
• Involved in Disaster recovery plan and also played important role in DR restoration.
• Performance Tuning & Establishing integrated change control.
• Published Reports to SharePoint Server utilizing Business Intelligence Development Studio.
• Scheduled Reports to be delivered to SharePoint Document Library.

Environment: MS SQL Server 2008R2 Enterprise Edition, SQL Server 2012, Oracle, SSMS, SSIS,SSRS, TOAD, SQL Plus, OLAP, OLTP, T-SQL, MS Excel, MS Access, Unix, MS Visual Studio.Net, VB, XP professional,2003, Crystal Reports XI.

Confidential, Atlanta, GA

SQL Server DBA

Responsibilities:

• Installation of MS SQL 2008 servers on production, Test and Development boxes.
• Handling user requested issues through Service Tickets.
• Involved in Change Control Management is the discipline of systematically identifying and controlling change requests to a project from both internal and external sources.
• Installed 64 bit SQL Server 2008 on Windows 64 bit Operating System
• Successfully installed SQL servers 2008 on cluster server.
• Migrated SQL Server 2005 database to MS SQL Server 2008
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Created SSIS Packages to migrate the data from database to Text files.
• Created database objects like tables, views, indexes, stored-procedures, triggers, cursors
• Deployed builds in Production servers for schema changes and worked in CMR(Change Management Request) department
• Successfully implemented Database Mirroring in SQL Server 2008
• Successfully Configured Snapshot, Transactional and Transactional with updatable subscription in Replication.
• Created Maintenance Plans for production servers (Full, Differential and Transactional Backups).
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Generated various monthly reports with the help of SSRS 2008.
• Installation of 32 bit and 64 Oracle 10g client and applied DST Patches for Oracle Linked servers
• Co-coordinating with the programmer analyst for optimizing query, writing stored procedures.
• Conducting Root Cause Analysis of application availability and narrow down to issues related to coding practices, database bottlenecks, or network latency
• Creating logins, groups, users, roles, database devices, databases, mirroring devices, checking for database consistency, fixing DBCC errors, monitoring error logs, database space allocations, transaction log space allocations, fine tuning SQL performance.
• Resolving Locking and Blocking issues by using various SQL server internal commands
• Scheduled and Monitored SQL jobs and used profiler for tuning.
• Installation of Service Pack 2 and Hot fixes for SQL Server 2008

Environment: Windows Server 2008 Enterprise Edition, SQL Server 2008, SQL Server 2005, SSAS, SSIS, SSRS, OLAP, OLTP, ETL, Replication, Clustering, Microsoft Office .

Confidential, Northbrook, IL

SQL Server Jr.DBA

Responsibilities:

• Installed and Configured SQL Server on SQL Server 2008 with Windows Server 2003 Cluster Server, on pre-production server.
• Setup new MS SQL Server instances in SQL 2008 and databases.
• Implement and maintain database security.
• Capacity planning of MS SQL Servers.
• Going through the clients' requirements and coming up with database design and application architecture.
• Plan capacity specification requirements for new database servers.
• Troubleshoot and minimize production down issues.
• Designed new job process, new database maintenance plans, DTS programs and did performance tuning of the existing processes.
• Implemented major changes to the MS SQL database for overall performance enhancement.
• Created Scheduled maintenances and backup procedures to the database as a disaster recovery method.
• Data conversions and data loads from various databases and file structures.
• Monitor failed and long running MS SQL Server jobs.
• Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.
• Support and maintenance of MS SQL Server Transactional Replication.
• Maintaining User account administration for Different domains.
• Data conversion from Text file, image into SQL Server Table.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Job scheduling and alerts.
• Designed and implemented user log in and security.
• Resolved any deadlocks issues with the Databases/Servers on a real-time basis.
• In-Depth working knowledge of ODBC.
• Created many complex Stored Procedures / Functions and used them in Crystal Reports directly to generate reports on the fly.

Environment: SQL Server 2005, 2008, T-SQL, Windows 2000, Crystal Report XI, Replication, DTS.

Confidential, NYC, NY

SQL SERVER DBA

Responsibilities:

• Installing all software upgrades for SQL Server.
• Identified and resolved the query performance using SQL Profiler and Index tuning wizard.
• Used Data Transformation Services (DTS) to populate data from various data sources.
• Worked on Migration of SQL Server 2000 instances to SQL Server 2005.
• Writing/modifying stored procedures, views and triggers to meet the current design.
• Involved in Creating SSIS packages to integrate the data coming from various data sources.
• Administering the MS SQL Server by creating user logins with appropriate roles, monitoring the user accounts, creating groups, and granting the privileges.
• Creating, modifying and monitoring replication on all databases.
• Monitoring database size & disk space in Production, Model and Development environments.
• Involved in Capacity Planning, Performance Tuning.
• Creating and monitoring all maintenance jobs like backups, integrity, and optimization on all databases.
• Periodic checking of databases with DBCC commands to maintain data consistency and integrity.
• Worked on upgrading DTS packages to SSIS packages.
• Worked with SQL Server Reporting Services (SSRS).
• Installing SQL Server service packs based on the errors and flaws that are found in the application.

Environment: MS SQL Server 2000/2005, T-SQL, DTS, Windows2003 Server, Windows NT, SSIS, SQL profiler, Upgrade Advisor.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application.
• Provided 24 X 7 dedicated supports for the claims records database.
• Provided 24 X 7 supports for Production environment.
• Planned and modified the permission issues in the production servers.
• Server & Application fine-tuning & trouble shooting, Monitoring MS SQL Server performance and windows server issues.
• Created the backup and restore strategy for production environment.
• Worked with SQL server Profiler generated traces to optimize the performance of the database.
• Installed and configured active/passive clustered environment.
• Rebuilding indexes on various tables.
• Resolving locking and blocking issues.
• Installed and configured SQL Server bit in a Test Environment and migrated & tested databases to production server.
• Implemented log shipping in standby mode to support DR servers.
• Documented and tested Merge replication in test environment for generating reports.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the performance of the server on daily basis in email format.
• Provided technical assistance and mentoring to staff for developing conceptual and logical database design and physical database.
• Assisted other teams in stress-testing applications, locating bottlenecks, and recommending possible solutions.
• Responsible for quality control and auditing of databases to ensure accurate and appropriate use of data. Worked with management to develop database strategies to support company needs.
• Responsible for creating and maintaining technical documentation for the database environment to follow HIPPA rules.

Environment: SQL Server 2000/2005 Enterprise Edition, Windows 2000 Advanced Server, Windows 2003 Enterprise Edition, IBM eServer pSeries platform, IBM Storage systems DS8300, DS6800s and DS 4800s.