Objective

• Seeking a position as a SQL Server DBA in initiatives that utilize state - of-the-art, software and/or hardware components with a creative, technology-driven organization in an environment that encourages innovative thinking, recognition and career development.

SUMMARY

• 6+ 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.
• Expertise in T-SQL writing stored procedures, triggers and functions.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert.
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and AAG.
• Worked on logical and physical data base modeling with VISIO 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.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Worked on SQL Server 2012 migration from SQL Server 2008 and 2005.
• Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
• 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.
• Working knowledge in Reporting Services (SSRS), SSIS and Clustering.
• Experience in supporting Very Large databases and troubleshooting the problems.
• Strong experience in mentoring team members and writing documentation.
• 24 X 7 Production Database on Call Support

TECHNICAL SKILLS

Databases: MS SQL Server 2012, 2008, MS SQL Server 2005

Programming: T-SQL, PL/SQL, VB Scripting

Operating System: Windows 2012/2008/2003 Advanced Server, NT & Windows 9x, Linux

Tools: SQL LiteSpeed, Visio, ERWIN, Remedy

PROFESSIONAL EXPERIENCE

Confidential, Falls Church. VA

SQL Server DBA

Responsibilities:

• Upgraded SQL server 2005 to SQL Server 2008 R2 in Microsoft Windows Server 2008 R2 Enterprise Edition
• Installed, Configured, and Managed SQL Server 2008, and 2005 in development, test and production environment
• Installed, Configured, and Managed SQL Server 2012 in development and test environment
• Checking Database Health by using DBCC Commands and DMVS
• Involved in Analyzing and Upgrading SQL Server 2005 test servers to SQL Server 2008.
• Having experience on SAN and RAID levels and building SQL Cluster servers on SAN Environments.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Resolved and tweaked memory pressures caused during product release.
• Troubleshoot performance problems and fine-tuning of databases.
• Expertise in designing databases and capacity planning.
• Rebuilding the indexes at regular intervals for better performance.
• Expert working SQL Server High Availability solution such as Windows Clustering, Replication, Log Shipping and Mirroring.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Reviewed physical and logical database design; Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.
• Monitored and modified Performance using execution plans and Index tuning.
• Transferring the data (ETL) to Data ware house by SQL Server 2008 Integration Services.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.
• Designed and created databases, tables, views, store procedures and triggers.
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
• In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development.
• Experienced in SharePoint 2010 for creating lists/libraries, adding/removing links, assigning permissions.

Environment: Windows Server 2008 R2 & 2012, SQL Server 2005, 2008 & 2012,T-SQL, PL/SQL, Erwin 4.1, JavaScript, MS IIS Server 5.0, SOAP, HTML, XML, Oracle8i, SharePoint 2010.

Confidential, Staten Island, NY

SQL Server DBA

Responsibilities:

• Performed server installation and configurations for SQL Server 2012 and 2008.
• Performed installation of SQL Server Service Packs.
• Upgraded databases from SQL Server 2008 to SQL Server 2012.
• Involved in capacity planning, sizing and database growth projections.
• Scheduled Full and Transactional log backups for the user created and system databases in the production environment using the Database Maintenance Plan Wizard.
• Setup backup and restoration jobs for development and QA environments
• Created transactional replication for the reporting applications.
• Implemented disaster recovery solution at the remote site for the production databases using Log Shipping.
• Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.
• Used System monitor to find the bottlenecks in CPU, Disk I/O and memory devices and improved the database server performance.
• Used SQL Server Profiler to monitor and record database activities of particular users and applications.
• Used DBCC commands to troubleshoot issues related to database consistency.
• Used Index tuning wizard to redesign and created the indexes for better performance.
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Streamlined the server/database level security by creating the Windows and SQL logins with the appropriate server/DB roles and object level permissions.
• Used Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Worked on upgrading DTS packages to SSIS packages.
• Implemented trigger and stored procedures and enforced business rules via checks and constraints.
• Worked with various business groups while developing their applications, assisting in database design, installing SQL Server clients, phasing from development to QA and to Production environment.
• Reviewed DB Scripts from the development team before releasing them into the Production.

Environment: Windows Server 2008 R2 & 2012, SQL Server 2005, 2008 & 2012,T-SQL, PL/SQL, Erwin 4.1, JavaScript, MS IIS Server 5.0, SOAP, HTML/DHTML, XML, Oracle8i.

Confidential, Gainesville. FL

SQL Server DBA

Responsibilities:

• Installed, Configured, and Managed SQL Server 2008 R@ on standalone servers in development environment and migrated databases from SQL Server 2005.
• Configured and Maintained four-Node Active/Passive Windows Failover Cluster with SQL Server 2008 R2 on SAN environment.
• Configured and maintained transactional and peer-to-peer replication and troubleshoot replication issues.
• Configured and administered Always On Availability Group in development environment.
• Designed and Deployed SSIS Packages to Export and Import Data from various Databases and Files.
• Performed Database Backup and Point-In-Time Recovery solutions using Quest LiteSpeed.
• Managed security and permission of SQL Server by Encryption, Roles and Synonyms.
• Created Database Objects like Stored Procedures, functions, Views, Triggers, user defined data types.
• Managed index usage and fragmentation and updated statistics in databases.
• Involved in troubleshooting and fine-tuning database performance and concurrency and root cause analysis.
• Worked on Query optimization and tuning using SQL Server Profiler, Database Engine Tuning advisor, and Activity Monitor and analyzing execution plan.
• Checked Database Health by using DBCC Commands and DMVS.
• Enforced Policy Based Management at Database Level as well as Table Level.
• Implemented Partitioned Table, Error handling through TRY-CATCH statement, Common Table Expression (CTE), MERGE statements.
• Developed reports using SQL ServerReporting Services (SSRS) and deployed in SharePoint.
• Involved in Data Modeling, Normalization, developing Logical/Physical ER Diagram using Erwin and SQL Server Data Diagram.
• Translated business requirements into technical design specifications and actively supported business users for change requests.
• Provided 24/7 on call support for all the Production Servers.

Environment: MS SQL Server2008R2/2005,Windows Clustering, Replication, Windows Server 2008R2 and Windows Server 2003, .Net Framework, C#.Net, JavaScript, MS TFS, MS-Access, Oracle 10g, LiteSpeed.