OBJECTIVE:

A position as a Senior SQL DBA where my significant SQL functional and technical knowledge and team work skills will be of great value to SQL Implementation and support projects.

SUMMARY:

• 9 years of experience in Database Administration and Development for very large and complex databases in SQL Server 2012 2008 R2/2008/2005/2000 comprising OLTP and OLAP environments.
• Expertise in installing MS SQL Server 2012 2008R2, 2008, 2005 and 2000, updating with latest service packs, hot fixes and security patches.
• Dexterity in implementing different types of High Availability Disaster Recovery scenarios like Replication models Snapshot, transactional , Log Shipping, Database Mirroring and Clustering.
• Migration of SQL Server 2000 databases into SQL Server 2005 and SQL Server 2008 as well as SQL server 2005 into SQL server2008.
• Experience in working with SQL Server 32 bit and 64 bit environments.
• Administered multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
• Proficient in SQL Server 2008 new features like Merge Statement, Filtered Indexes, Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption TDE , Backup compression, Lock escalation and new data types.
• Implemented the new SQL Server 2005 concepts like Data partitioning ,Snapshot Isolation, Database Mirroring, Database Snapshot, DDL triggers, Try-Catch blocks, Online Indexing, Online Restoring, DMV's, DMF's, Mail Setup, Jobs, and Alerts, Database Tuning Advisor, SQLCMD
• Configured SQL Maintenance Jobs in 2005/2008 environments.
• Configured more than 2GB RAM in 32 bit environment using AWE and /3GB switch
• Expertise in Performance Tuning, Index Tuning Wizard, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity, and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
• Involved in Risk Management and solved many Issues on Security and Logins and Space.
• Exquisite skills in SSMS-Creating and scheduling jobs, alerts and operators with SQL Server Agent, handling Backup warm, hot and cold backups /Recovery of databases, Replication, Linked Servers, Database Maintenance Planning.
• Expert in using Native tools like SQL server profiler, database tuning advisor, perfmon.
• Expertise in resolving locks, deadlocks, handling Isolation level and concurrency effects, detect CPU, I/O, Memory bottlenecks.
• Sound knowledge in writing complex SQL Queries, stored procedures, Normalization, Database Design, creating Indexes, Indexed views, file group modifications, User Defined Functions UDF , Triggers, Distributed Queries, Common Table Expressions and adding scheduled jobs to re-index and update statistics in databases.
• Expertise in reading and understanding execution plan and fixing query to execute with low cost using various operators depending on the scenario.
• Acquaintance in supporting Very Large databases VLDB 2TB and troubleshooting the problems in OLTP Environment
• Expertise in extracting and transforming data using data transformation services like import/ export wizard, BCP, Bulk insert, attach/detach.
• Prowess in planning and implementing Database Security by creating Logins, Users, Roles, and assigning permissions to them
• Experience in developing and tuning SQL Server Integration Services SSIS packages, Analysis Services SSAS cubes and Reporting Services SSRS reports and models.
• Proficient in high level design of ETL, DTS Packages and SSIS Packages for integrating data using OLE DB connection from heterogeneous sources Excel, CSV, Oracle, flat file, Text Format Data by using multiple transformations provided by SSIS such as Aggregate, Data Conversion, Conditional Split, Bulk Insert Fuzzy Grouping, Fuzzy Lookup ,OLEDB Command and Merge.
• Proficient in Migration of data from Microsoft Access to SQL Server.
• Leveraging SSIS to integrate data from source SQL Server databases to build the datamart.
• Experience in Creating Report Subscription, Data Driven Subscription, Report Snapshots and caching, linked, cascaded and parameterized reports, complex drill down reports using SQL Server reporting services SSRS . Configuring and maintaining Report Manager and Report Server.
• Expertise in Setup of SharePoint Server MOSS 2010 Configuration of its Services
• Good understanding with SQL based reporting tools like Crystal Reports.
• Experience in designing, creating, processing of Cubes using SSAS and using MDX Queries.
• Expert in data warehouse modeling designing Star Schema, snowflake schemas with identifying Facts and Dimensions .
• Experience in Software Development Life Cycle SDLC , Analyzing and Designing systems using Structured Methodologies ERD, DFD along with extensive knowledge of Relational Database Management Systems with in-depth of T-SQL.
• Created Linked Servers between SQL Server Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.
• Handled numerous Change Management requests on production servers
• Explicitly used Litespeed, Foglight, Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas
• Strong experience in mentoring team members and writing documentation.
• Good Knowledge on Concepts like RAID levels and NORMALIZATION.
• Worked extensively on Postgres SQL and have converted several Postgres SQL functions to native SQL server stored procedures.
• Worked with Microsoft CRM 2013 for web services through Sharepoint MOSS
• 24 X 7 Production Database on Call Support.
• Knowledge in VB, VB.NET and C
• Good experience in configuring and troubleshooting IIS and XML.
• Implemented VMware in cluster environments.
• Have very good experience in mentoring team members in Sharepoint and Litespeed 6.5 versions.

Technical Skills:

PROFESSIONAL EXPERIENCE

Confidential

Senior Database Administrator, SQL Server

Description: Confidential, is a market research firm, known for the Harris Poll. Harris works in a wide range of industries, across countries and territories through North America, Europe, and Asia. The company is a member of several research organizations, including the US National Council of Public Polls, the British Polling Council, the Council of American Survey Research Organizations, the US Council for Marketing and Opinion Research, and the UK Market Research Society.

Responsibilities:

• Installed and configured SQL 2012 and upgraded migrated SQL 2008/2008R2 to SQL 2012
• Configured and maintained High availability and high safety mode of Database Mirroring and Active-Active and Active Passive Clustering on 2008 SQL SERVER.
• Administering database privileges and security within corporate standard operating procedures
• Optimizing maintaining database performance through active monitoring, scheduled upgrades, service pack installations, and performance tuning using DBCC, DMV commands and perfmon counters.
• Providing 24/7 on call administration, production support and deployment activities as required to maintain corporate databases
• Maintaining documentation and standards for DBA tasks, providing input on improving departmental processes
• Designing corporate databases by analyzing data storage and reporting requirements while enforcing all database standards
• Conducting on-going mentorship and training of Database Operations staff
• Setting up internal meetings to provide data strategy recommendations and guidance every week
• Participation in corporate database architecture, development, deployment and capacity planning
• Planning, coordinating and implementing security measures to safeguard databases from accidental damage or unauthorized access or modification with a good Disaster recovery plan.
• Identifying and evaluating industry trends in database systems to serve as a source of information for management through active participation in the SQL Community.
• Extensive use of 3rd party tools Commvault backups and Idhera performance monitor
• Evaluating daily and weekly tasks through TFS.
• Migrating SQL servers from VMware to Physical servers and vice versa.

Confidential

Senior Database Administrator, SQL Server

Description: With 4.4 million customers and more than 42,000 megawatts of generating capacity, Atlanta-based Southern Company is the premier energy company serving the Southeast. One of the largest producers of electricity in the United States, Southern Company owns electric utilities in four states: Alabama Power, Georgia Power, Gulf Power, Mississippi Power, serving 120,000 square miles in four states and a growing competitive generation company, as well as fiber optics and wireless communications. Southern Company brands are known for excellent customer service, high reliability and retail electric prices that are significantly below the national average.

Responsibilities:

• Created Scripts for Backups, Restores and also Backup cleanup jobs that ran every night. And also scripts for Cycling error logs and space reports
• Built and managed Cluster environments in Production and Development Environments. Worked on Failover Clustering between two nodes in both Active-Active and Active-Passive.
• Design, built, and maintained other high availability options such as failover clustering, Database Mirroring, Log shipping between two different environments and servers using both SQL Server native and Quest LiteSpeed 6.5 , Replication Transactional .
• Built Installed and managed huge number of SQL Server 2005/2008/2012/2008R2 Servers.
• Installed and configured SQL 2012 and worked on new features like ALWAYS ON availability.
• Worked heavily on Ticketing tool: Remedy and Clarify web which mainly had issues with Space on disks, Backup jobs failing, Security Logins, User roles ets .Hence did a lot of Performance Tuning and Query Optimization to know the errors and to give optimal performance.
• Upgraded servers and SharePoint sites from SharePoint 2007 on to MOSS 2010 which reside on SQL Server 2008 R2.
• Manage 250 complex SQL Servers 2000, 2005, and 2008 which include production, test, user-acceptance, development servers by resolving all issues in a fast past environment 1500 databases .
• Design, build, and maintain stand-alone SQL Servers to include disaster recovery, capacity planning, real-time monitoring, troubleshooting, and proactive maintenance.
• Ensure backup, recovery, performance enhancement, and disaster recovery for all SQL Server databases and applications.
• Write T-SQL scripts for customers and vendors in support for data, table structure, and stored procedures changes.
• Support multiple applications to include but not limited to Microsoft SharePoint and Team Foundation Server.

Confidential

SQL Server DBA

Description: American Home Mortgage Servicing Inc. AHMSI provides services to homeowners and loan investors. Whether a borrower holds a traditional, Alt A, payment option or subprime loan, their highly trained experts are committed to providing high levels of service as they work to address each customer's needs. Similarly, they also carefully manage the loan portfolios of investors, giving them the attentive service that they appreciate.

Responsibilities:

• Implemented 2008R2 Active-Passive Cluster in Windows 2008 Environment.
• Setup and maintained Database Mirroring with automatic failure.
• Migrated Databases from SQL Server 2005 to 2008 and 2008R2.
• Performed compressed native backups, used backup compression techniques, VERITAS Net Backups.
• Restoring backups from 2005, 2008 Server on to 2008R2 Server.
• Used Import/Export wizard and BULK INSERT, batch commands, scripts to insert huge amounts of data in the Databases.
• Created Maintenance plans, Update Statistics to improve performance, Rebuild indexes to reduce the fragmentation in 2008R2, 2008, 2005 Environment.
• Created jobs, alerts, activity logs, error logs to capture any possible errors.
• Expert in Performance Tuning, Analyzed long running queries and tuned them to optimize the system performance.
• Used Perfmon, DMV's, SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Advisor for index recommendations.
• Writing T-SQL queries, Views, Stored procedures, creating Clustered and Non-Clustered Indexes.
• Installed, Configured, Authored and Managed reports using SQL Server 2008 Reporting Services.
• Performed Slipstream, Silent installation of SQL SERVER 2008.
• Refreshed data periodically from DEV to Staging and Staging to Production environments.
• Managed Security using Logins, Roles for various users.
• Documented all the installations, configuration changes, production issues.

Environment: SQL Server 2008R2/2008/2005, Cluster, Reporting Services SSRS , SharePoint 2010, INFOPATH 2010, Windows 2003, 2008.

Confidential

Senior SQL Server DBA

Description: Confidential is a large U.S. law firm and lobbying group based in Pittsburgh, Pennsylvania. The firm has over 500lawyers in sixteen offices nationwide, and was ranked 82nd on the National Law Journal's 2008 list of the 250 largest law firms in the United State.

Responsibilities:

• Managed and Administrated the SQL Server 2008/2005/2000 production and Non-production servers.
• Installation of SQL Server 2008/05 and service packs on Windows Server Clustered environment.
• prepared maintained and modified SQL server installation and configuration documents
• Upgraded/Migrated SQL Server 2005/2000 databases to SQL Server 2008 databases including DTS to SSIS packages and mentored Jr.DBAs and other technical staff.
• Migration from Dev to QA to prod environments
• Performed backup using backup compression and Data compression in SQL Server 2008 on clustered environment
• Handled up to 1.5 TB Size databases with clustered environment.
• Implemented new features in SQL 2008 like Policy based Management, Table Compression backup compression, SQL Server Auditing, Resource Governor and MERGE statement in T-SQL.
• Application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• Set up and Monitored transactional replication, Database mirroring on Production, QA and Dev servers and trouble shooting of errors.
• Extensively worked on Profiler, Perfmon, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
• Managed Security using SQL Logins, Roles and Security Modes for various users.
• Rebuilding the indexes on regular intervals and placing the huge table/non-clustered index on the separate file group to improve the performance.
• Optimized the query performance with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Analyzed execution plans and generated suggestions for improvement.
• To set up SQL Server configuration settings to resolve various resource allocation memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Configured data partitioning/table partitioning on huge tables containing millions of rows for better performance.
• Monitoring SQL Server logs to ensure whether the backup operations, batch commands, scripts have completed successfully.
• Handled numerous change management requests on production servers
• Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks.
• Created SSIS packages to load robust data from different Heterogeneous data sources like Oracle, DB2 to SQL server.
• Created, scheduled database maintenance plan using SSIS Maintenance plan task.
• Configured and deployed SSIS Packages from Test to Production Environments.
• Created, deployed and managed reports using SQL Server Reporting Services SSRS
• Monitored production environment
• Used Online Indexing and online Restoring in SQL 2005.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas
• Extensively used Repositories like Team Foundation Server TFS
• Supported 24 X 7 Production environment

Environment: SQL Server 2000/2005/2008 Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services DTS , MSSQL Server2000 Analysis Server

Confidential

SQL SERVER DBA

Description: The Rhode Island Department of Transportation RIDOT is agency charged with construction, maintenance and inspection of a wide range of transportation infrastructure. Two large bridges, the Claiborne Pell Newport Bridge and the Mount Hope Bridge, are under the responsibility of the R.I. Turnpike and Bridge Authority.

Responsibilities:

• Migrated SQL Server 2000 databases to SQL Server 2005, DTS packages from SQL Server 2000 to SSIS SQL server 2005.
• Maintained and modified SQL server installation and configuration documents
• 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.
• Evaluated data storage considerations to store databases and transaction logs. Created databases using Transact SQL Statements, SQL Server Management Studio and Database Wizard.
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression CTE , Data Partitioning, Snapshot Isolation
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Identified, tested and resolved database performance issues monitoring and tuning to ensure data optimization.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Managed trouble shooting of Client connections, viewing error log and applications.
• Developed automated backup and DBCC scripts for databases and transaction logs.
• Maintaining the database consistency with DBCC utility at regular intervals.
• Worked on log shipping for synchronization of database.
• Worked in Cluster Environment.
• Authenticated logins and validated permissions. Created SQL Server Database users and Roles.
• Writing stored procedures, triggers, and functions and maintained coding standards.
• Involved in database Normalization, logical and physical data modeling using ERWIN.
• Created and supported complex database schemas.
• Managed VERITAS net backups and Litespeed backups.
• Used SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Advisor for index recommendations.
• Installed SQL Server 2005, Service Packs and created Development Database for testing, upgrades and development.
• Monitored servers using Spotlight third party software.
• Transferred data ETL to Data warehouse Environment using SSIS.
• Maintained SSIS packages
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Worked on DTS, Import and Export utility, for transferring data.
• Maintained views, stored procedures, indexes
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services
• Configured IIS, Report manager, Report server and implemented role based security to end users and developed report models for creating Ad-hoc reports using SSRS.
• Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
• Configured SQL Server settings using configuration manager.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas
• Involved with development team and developed functions, procedures and packages performed Logical Backups by Export and Import utilities.
• Handled numerous change management requests on production servers
• Extensively used Repositories like Team Foundation Server TFS

Environment: Windows 2003 server, VB.NET, XML, MS SQL Server 2005/2005, T-SQL, MS Access, MS Excel, Oracle.

Confidential

SQL Server DBA/Developer

Description: Citigroup Inc. Citi is a major American financial services company based in New York City. The Financial team will be providing financial services and financial tools. The objective of this project was to create a Consolidate Reporting Project. Build a data mart for the Retail Customer Service department. The data is from the call center coming from different modules.

Responsibilities:

• Database Administrator, Database Programming.
• Relocation of Databases from one server to another server using attach and detach databases.
• Implemented Cluster in Active Passive clustered environment.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Migrated DTS packages from Legacy system to SQL SERVER 2005.
• Using the Litespeed to take backups.
• Migrated data from Oracle to SQL Server
• Involved in Weekly Change Management, in which code developed by developers is being run on production server.
• Implemented log shipping between two instances of servers using Database Maintenance Plan by creating a Monitor server and a shared Folder.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Monitored and modified Performance using execution plans and Index tuning.
• Recovering the databases from backup in disasters
• Maintaining the database consistency with DBCC at regular intervals
• Used DTS packages to move logins and jobs from one server to another server.
• Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool.
• Transferred data ETL to Data ware house Environment using SSIS
• Used Data Partitioning in SQL Server 2005.
• Used Snapshot Isolation in SQL Server 2005.
• Using log shipping for synchronization of database.
• Good experience in data modeling and metadata services.
• Expertise in SQL Server Reporting Services SSRS .
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Maximum performance and uptime in production environment.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Handled up to half TB Size databases with clustered and replication environment
• To set up SQL Server configuration settings to resolve various resource allocation memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• To implement all database development enhancements to multiple SQL Server databases to ensure a flawless functioning of production environment.
• To perform installations performance tuning, manage capacity planning user accounts, and implement database security for multiple instances of development, certification, QA, and production SQL Servers databases.
• To design develop data models and perform forward and reverse engineering using data modeling tools like ERWIN.
• 24 X 7 Production Database on Call Support.

Environment: SQL Server 2000/2005 Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services DTS , MSSQL Server2000 Analysis Server , Crystal Reports 8.0, XML, ASP.Net, VB Script.

Confidential

SQL SERVER DBA

Description: Pfizer Incorporated is a pharmaceutical company, ranking number one in sales in the world. The company is based in New York City. Pfizer applies science and its global resources to improve health and well-being at every stage of life. Its diversified global health care portfolio includes human and animal biologic and small molecule medicines and vaccines, as well as nutritional products and many of the world's best-known consumer products.

Responsibilities:

• Involved in the migration of SQL Server 2000 databases to SQL Server 2005
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services
• Evaluated data storage considerations to store databases and transaction logs. Created databases using Transact SQL Statements, SQL Server Management Studio and Database Wizard.
• Managed trouble shooting of Client connections, viewing error log and applications.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• 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.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression CTE , Data Partitioning, Snapshot Isolation
• Transferred data ETL to Data warehouse Environment using SSIS.
• Managed VERITAS net backups and Litespeed backups.
• Monitored servers using Spotlight third party software.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Maintaining the database consistency with DBCC utility at regular intervals.
• Using Log shipping for synchronization of database.
• Worked in Cluster Environment.

Environment: SQL Server 2005/2000, VB.NET, ASP, .NET, Windows 2003.