SUMMARY

• 8+ years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2012, SQL Server 2008 R2, 2008 and 2005.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
• Expertise in T - SQL writing stored procedures, triggers and functions.
• Expertise in using .NET tools like LINQ, Entity Framework, SSDT, and Data Dude GDR.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Expert in data transformation services like SSIS/ETL, DTS, BCP and Bulk Insert.
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, contained Databases and, security principals.
• Worked on logical and physical data base modeling with UML and ERWIN tools.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Experience in Disaster Recovery Planning and Security Management operations.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Having hands on experience in DR processes including Log shipping and Database Mirroring.
• Worked on configuring SQL Server with minimum privileged access.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Worked on SQL Server 2012 migration from SQL Server …
• Experience on 64 bit SQL Server 2012/SQL Server 2008 R2 systems and MSCS Configurations.
• Having Experience on Data center servers and handling more than 1.0 TB databases.
• Handling Memory configurations for SQL Server 2012 and SQL Server 2008 on Windows 2008.
• Proficient in Visual Studio … for managing, deploying and producing .NET based applications.
• Experience in LDAP, Active Directory and its relationships.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g.
• Also created DTS package for data transfer between the two environments.
• Experience in SSIS, SSRS, SSAS and Clustering.
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• Strong experience in mentoring team members and writing documentation.
• 24 X 7 Production Database on Call Support.

TECHNICAL SKILLS

DBA: Database Administration of MS SQL Server 2012, 2008, 2005

ETL Tools: SSAS, SSIS using BIDS, Informatica Power Center 9.x, ODI, DataStage

Business Intelligence: MSBI Suite(SSIS, SSRS, SSAS) Databases SQL Server … … Oracle …, MySQL, MS Access

Languages: SQL, PL/SQL, .NET(C#), C

Web Technologies: HTML, DHTML, XML, XAML, XSL/XSLT

Design: Erwin, Visio, Aqua Studio, Enterprise Architect, MySQL workbench, SQL Developer, Data Modeler, SQL Server Diagram Editor, TOAD Data Modeler, Visual Studio 2010/08

Tools: MS Office Suite, TOAD, SQL Plus, SQL Developer, Autosys r11.x, SQL Developer Data Modeler

Operating Systems: Windows … Advanced Server, NT & Windows 9x, Linux

Version Control: Team Foundation Server, Visual Source Safe, SVN

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

PROFESSIONAL EXPERIENCE

Confidential, Upper Saddle River, NJ

Sr SQL DBA

Responsibilities:

• Installed and maintained MS SQL Server 2000 on Windows 2003 Server, according to the company standards.Utilized RDBMS on a daily basis to administer SQL DBA duties, interface for HL7 transmissions, applications, data extraction and migrations as well as conversions.
• Upgrade experience of SQL Server . Experience in applying Service Packs at database and OS Level.
• Upgrading MS BI stack from SQL 2005 to SQL 2012. Migrated DTS packages to SSIS (SQL Server Integration Services).
• Assisted with the implementation of Snapshot and Transactional Replication for the reporting databases.
• Created the Maintenance Plan for optimization and integrity check for all SQL servers.
• Used DBCC utilities, updated index statistics, monitored database and disk space; involved in security issues and scheduled tasks.
• Worked on migration and maintenance of data using various utilities like DTS, Import and Export via BCP.
• Monitored Databases for Lock Escalation, Deadlock, resource utilization by sessions, capturing long running SQL queries, fine-tuning SQL statements that better result in efficient SQL statements processing.
• Modified existing Stored Procedures and Functions.
• Worked on creating SQL traces using SQL Profiler Wizard.
• Performed administrative activities like creating user logins with appropriate roles, granting and denying login privileges, monitoring the user accounts, creation of groups, granting database and application roles to users and groups.
• Installed and maintained the Failover Clustering Architecture for SQL Server databases for mission critical applications.
• Split large tables using data partitioning.
• Performed Full Backups and Transaction Log Backups. Restored them whenever necessary; created backup strategies and worked on scheduling the backups.
• Dropped and recreated the indexes on tables for performance improvements.
• Automated processes using SQL Server Jobs.
• Used Index tuning wizard for tuning of indexes.

Environment: MS SQL server … Windows 2003, Enterprise Manager, Query Analyzer, ASP.NET, MS BI and SSIS.

Confidential, San Francisco, CA

MS SQL Server DBA

Responsibilities:

• Performing SQL server daily health check and preparing a report based on it.
• Monitoring Disk Space of all the Servers and freeing up space as per SQL Server i.e. Older Backups, Unused Files etc.
• Handling creation of new SQL Server databases as per Client/Application Team request using Build Sheet Template.
• Provide detailed project plan, project proposals, and project scope for projects involve the MS BI Studio and SSIS.
• Participated in DR installation and trouble shooting (Mirroring, Logs hipping and High availability Cluster.
• Applying Service Packs and Security patches for the Servers as released.
• Installed SQL Server … on Active/Passive and Active/Active clusters as part of Upgrade.
• Monitoring the Log Space for successful execution of all the specified jobs.
• Managing backups on a daily basis and recovery (as per request).
• Reviewing SQL Server and SQL Server Agent Error Logs.
• Monitoring of server performance by profiler during peak periods of server utilization.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security policies and also preparing Auditing Reports for following auditing standards.
• Setting Perform counters for monitoring the server as per request about degraded performance from Application Team and then passing the trace files for L3 for an advanced review.
• Configuration and Maintenance of Log Shipping, Mirroring & Replication across different environments.
• Develop, implement and administer database policies and procedures and provide technical support and assistance to all database end-users.

Environment: SQL Server 2005, SQL Server 2008, Windows 2008, Windows 2003 EE, Cluster. MS BI Studio

Confidential, Richmond, VA

SQL DBA

Responsibilities:

• Installation and configuration of SQL server 2008 and 2008R2 on standalone and clustered environments.
• Configured SQL server clustering, log shipping, mirroring and replication.
• Implemented active\passive and active\active clustering and installed SQL 2008R2 for production application support.
• Worked on datacenter migration from VA to St. Louis.
• Using upgrade advisor analyzed and resolved all the issues encountered in migrating from SQL Server 2000 to SQL Server 2008.
• Using DTS Xchange tool to convert DTS packages to SQL Server 2008 SSIS packages.
• Implementing database standards and naming convention for the database objects.
• Converting and deploying of existing DTS packages to integration service (SSIS) packages over the development, testing and production environments.
• Using Microsoft business intelligence development studio for creating ETL packages and reports.
• Creation of SSIS packages to extract, transform and load into the campaign database
• Ensured constraints and writing triggers to apply business rules.
• Performance tuning, backing up and restoring user databases.
• Involved in designing and implementation of data warehousing solution which includes Building an OLAP database, creating data source.
• Configured and maintained transactional for different environments and also setup the jobs to capture the latency instead of using tracer tokens
• Extracted data from SQL Server for report, backup, testing purpose by using SSIS
• Managed databases on multiple disks using RAID technology.
• Developed T-SQL stored procedures/functions to process data and populate them in the appropriate destination tables.
• Setup change data capture on replicated tables
• Create MDW database to monitor all the instances of SQL server
• Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server's logins (Windows and SQL Accounts).
• Configured and maintained transactional and merge replication for different environments.
• Creating various Jobs, scheduling & running jobs and troubleshooting the failed jobs.
• Expertise in monitoring and troubleshooting SQL server performance issues.
• Worked on various tools like SQL LiteSpeed for backups.
• Tuning of slow running queries or inefficient queries for optimal performance using SQL profiler and managing indexes and statistics.
• Monitoring the database server's health and tuning accordingly.
• Provided 24 x 7 production supports for the database and application issues.

Environment: MS SQL Server 2008, 2005, 2000, BPA, Performance Dashboard, T-SQL, SSIS, SSRS, DTS xChange tool, TSM, TSRM and Windows … Servers.

Confidential, Madison, WI

SQL DBA

Responsibilities:

• Responsible for MS SQL server 2005, configuration, tuning and provide 24 X 7 dedicated support to all production, development and clustered servers.
• Involved in data migration from SQL 2005 to SQL 2008.
• Performed all aspects of database administration, including data modeling, backups and recovery.
• Prepared technical specifications for the development of SSIS (ETL) packages to load data into various target tables and defining ETL standards.
• Resolved the SQL server 2005 upgrade hurdles and successfully migrated SQL 2000 DTS packages to SSIS using upgrade advisor and package migration wizard.
• For complex packages like password protected packages, packages created using SQL native client used DTS Xchange tool.
• Worked as project lead on the actual tools and custom code upgrade/conversions as well as lead on actual deployment team.
• Developed advanced queries, triggers, views, and indexes using T-SQL.
• Installation of replication server, configuration and monitoring the replication, implemented transactional replication writing scripts for automation, for creating publications, articles and running the snapshot agent job, so that the same scripts can be used from system test to production
• Created logical and physical data modeling for development database using ERWIN tool.
• Wrote and integrated stored procedures to generate the reports.
• Specialized in designing clustering environments (active/passive and active/active) to further increase scalability and stability of business critical systems.
• Wrote complex stored procedure, queries, triggers, functions, user-defined functions and cursors for application.
• Created different types of reports such as drill-down, summary, form, OLAP and sub reports, and formatting those using SSRS 2005.
• Experience in creating parameterized reports and linked reports with thorough knowledge of report serving architecture. (table, chart and matrix report)
• Additionally, designed and implemented a disaster recovery system.
• Running index tuning wizard and rebuilding indexes for faster query response.
• Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server's logins (Windows and SQL accounts).
• Prepared estimates for database, table size growth.
• Setting up, configuring and troubleshooting Log shipping for databases on disaster recovery (DR) servers.
• Expertise in security issues such as creation and granting permissions on various objects.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes.
• Monitoring the event logs and server error logs for troubleshooting.

Environment: Windows 2003 Server, SQL … Enterprise Edition, Oracle 10g, SSRS, SSAS, SSIS, Performance Point Sever 2007, T-SQL, ASP.NET2.0, C#.NET, ADO.NET, Microsoft Visual Studio.Net 2005, .NET Framework 2.0, EXCEL2007.

Confidential, Boston, MA

SQL DBA

Responsibilities:

• Installation and configuration of SQL Server 2005 components in Prod/Development, and UAT.
• Installing and configuring Windows 2003 fail over cluster for SQL 2000& 2005.
• Migration of windows Cluster and implementation MS SQL 2000 to MS SQL 2005.
• Migrated DTS packages to MS SQL 2005 SSIS Packages and troubleshooting migration issues and compatibility.
• Administration of Clustered SQL servers in 24 x 7 Windows data center environment.
• Designing, testing and managing disk\tape Backups and Recovery strategies.
• Managing Log Shipping for warm stand by computers.
• Managing Replication of Data (Snapshot, Transactional, Merge method used).
• Managing SQL databases, Security, fine tuning of SQL queries, troubleshooting.
• Designing and managing SQL DTS and SSIS Packages.
• Developing SQL stored procedures, views and triggers.
• Responsible to releases from development to test to production environments.

Environment: Windows 2000 Advanced server and Enterprise Server 2003, MS SQL Server … and Oracle, TSQL, Erwin, Flat Files, PL/SQL.