SUMMARY

• Over 9 years of IT experience in SQL Database Administration, System Analysis, Design, Development & Support of MS SQL Servers 2012, R2, 2008, 2005 and 2000 in Production, QA, Reporting, Staging, UAT, Development, Replication and Clustered Server Environments.
• Expert in handling production systems in 24/7 environment
• Good knowledge in Administering and managing Databases ranging several gigabytes.
• Installed and configured MS SQL Server 2012/2008 R2/2008 and 2005 systems in all environments
• Knowledge in upgrading and migration systems from MS SQL Server 2005 to MS SQL Server
• 2008\2008R2
• Good knowledge in tuning MS SQL Server 2008/2005 systems for optimal performance
• Good skills in handing MS SQL Server systems in Clustered environments on 2008/2003
• Implemented SQL Clustering for MS SQL 2008/2005/2000
• Published Reports to SharePoint Server utilizing Business Intelligence Development Studio.
• Scheduled Reports to be delivered to SharePoint Document Library.
• Good knowledge in implementing log shipping mechanism (Manual & Wizard)
• Implemented Database Mirroring on SQL Server 2008/2005 systems
• Sound knowledge of performance tuning MS SQL Server 2008/2005 for best performance
• Experience in fine tuning parameters on operating systems
• Good skills in using SQL Server 2008/2005 profiler trace for bottlenecks and long running queries
• Good knowledge in fine tuning stored procedure for super performance
• Good knowledge in fine tuning queries taking a long time
• Good knowledge in understanding query plans and statistics data
• Good Knowledge in Querying the databases using the Powershell scripts.
• Experience in Creating, Suggesting and implementing Indexes (Clustered, Non Clustered and
• Unique)
• Worked on using tuning wizard in MS SQL Server 2008/2005
• Implemented sound backup strategy for all MS SQL Server 2012/ 2008/2005/2000 database servers
• Timely full backup / Differential backup and transaction log backup for all production,
• Development & QA systems.

TECHNICAL SKILLS

RDBMS: SQL Server 2012/2008R2/ 2008/2005/2000 .

Database Tools: Management Studio, BI Development Studio, SQL Profiler, Data Transformation Services (DTS), SQL Server Integration Service (SSIS), Sharepoint,SQL Server Analysis services(SSAS), SQL Server Reporting services(SSRS), Erwin, Microsoft Visio.

Languages: SQL, TSQL, Visual Basic 6.0, HTML

Web Tools: MS - Front Page, Internet Information Server (IIS), MS-Outlook Express.

Applications: Microsoft Office, Erwin, MS VISIO 2003/2005.

Operating Systems: Windows 95/98/ 2000/2003/2008 R2 and win 7, XP, Linux, MS-DOS

PROFESSIONAL EXPERIENCE

Confidential, Danville, PA

Sr MS SQL Server DBA

Responsibilities:

• As a Production and development support DBA responsibility for maintenance on 520 SQL Server out of which more than 300 servers are Production Servers and rest all are Development and Staging servers.
• Responsible for migrating SQL /R2 versions to SQL 2012 with proper planning and documentation in place.
• Implementing new features of SQL 2012 like Always on, Column Stored Indexes & Contained Databases in newly migrated servers.
• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
• Configured Database mail, linked servers in SQL server 2012.
• Installing, Configuring and maintaining Lite Speed for SQL Servers for backups & Restores.
• Extensive knowledge on Backup and restore database process.
• Have good knowledge on Always on new features.
• Good knowledge on Idera third party tool for database backup and restore.
• Created and scheduled SQL JOBS thru SQL Agent.
• Working closely with Development & Application teams to guide with best practices on writing tsql queries
• Writing Powershell scripts to make enhancements to existing functionality.
• Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity
• Worked on Remedy tickets like Lotus notes.
• Worked on Foglight performance tools.
• Configured SQL Server Mirroring for High Availability across all production servers in SQL Server 2008 R2.
• Involved in migration of databases from SQL Server 2008 R2 to SQL Server 2012.
• Worked on creating new users and roles.
• Managing SQL server using PowerShell scripts.
• Managed SQL security for all users.
• Created maintenance plan for good running database health.
• Good knowledge on Log shipping and replication
• Created monitoring scripts to alert for blocking, dead locks, sql agent job failures, backups etc.,
• Working with SCOM to monitor server across all the domains.
• Good knowledge on system maintenance procedure like upgrade all Microsoft Products,
• Patches, defrag the all Drives, apply OS updates (including thoroughly tested service pack).
• Apply application specific updates (SQL post SP4, Exchange post SP3 hot fixes).
• Good knowledge on upgrade process from & 2008R2.
• Provide good support to the Developer and QA Environment.
• Involved in DR (Disaster recovery) environment
• Created the standard operating procedures (SOP) for SQL Clustering, replication and log Shipping. configuring and maintaining transaction and snapshot replication to replicate the data to remote servers.

Environment: MSSQL 2 2008 R2, VMware, Citrix Server, IIS, windows OS, win 7, Windows Cluster Server, BIDS 2005/2008/R2, SSDT 2012, SQL Server Management Studio, Query Analyzer, SQL Profiler, Performance Monitor, SSIS, SSRS, Remedy, Lite Speed, TSQL, Stored Proc’s, SOX, Triggers, UDF’s, Constraints, DTS, BCP, Data Compression, Partitioning, Joins, DDL, DML, Cursors, Server Migration, Batch Files, Centralized Schema Repository, SAN, PowerShell, Active Directory, ODBC etc.

Confidential, Charlotte, NC

MS SQL Server 2008/2005 DBA/ Developer

Responsibilities:

• Monitoring of database size and disk space in Production, Staging & Development environments
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration. Security and architectural planning issues met as well as testing and training.
• Performed installation of SQL Enterprise bit version on Windows 2003 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers. Patch applications.
• Most of the servers are Virtual Machine (VM).
• Responsible for 57 Oracle and SQL Server databases on 11 servers.
• Oracle 8i & 9i DBA for GIS and electric Intel databases.
• Extensive knowledge on Internet Information Services (IIS).
• Worked on Command Prompt (CMD).
• Extensive knowledge in Virtual Machine (VM) and install the main versions of VM VMware Vsphere Client.
• Failover cluster testing and resolution on HP servers as well as monitoring and backup reporting setup with
• Microsoft Operations Manager and backup teams.
• Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity.
• Creation and scheduling of Maintenance plans (database and log backups and cleanups), DTS to SISS package conversions. Business Intelligence package design. Created tables and performed data imports and restores for successful migration. Scripting development and troubleshooting for various security syncing scripts to new databases as well as creation of database roles for granting Stored Procedure rights.
• Good knowledge on CITRIX servers and Uptime Monitoring Systems.
• Using third party tool like LITE SPEED for backup and restore the databases.
• Worked on Remedy tickets like Change Management Request v3.0 (CMR).
• Good knowledge on system maintenance procedure like upgrade all Microsoft Products, Patches, defrag the all Drives, apply OS updates (including thoroughly tested service pack).
• Upgrade the latest Net Backup client on the systems.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS packages.
• Documented up gradation procedures from MySQL to SQL Server and Oracle to SQL Server.
• Migrated Databases from MySQL, Oracle to SQL Server 2005.
• Apply application specific updates (SQL post SP4, Exchange post SP3 hotfixes).
• Gave a good support to the Developer and QA people.
• Involved in creating SSIS packages. And wrote some SQL queries.
• Develop and implement complex T-SQL, VBScript and PowerShell scripts for administration tasks.
• Created the standard operating procedures (SOP) for SQL Clustering, replication and log Shipping.
• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
• Configured Database mail, linked servers in SQL server 2005.
• Experienced in configuring and maintaining transaction and snapshot replication to replicate the data to remote servers.
• Created the DTS packages to import and export the data from Oracle, MS Access and text files to SQL Server.

Environment: MSSQL 2005/2008/2008 R2, VMware, Windows 2008 server, Windows Server 2003(x64), Windows Cluster Server, Windows Server 2000, BIDS 2005/2008, SQL Server Management Studio, Query Analyser, SQL Profiler, Performance Monitor, SSIS, SSRS, CA Service Desk, IT Service Catalog, SOX, Avamar, TSQL, Stored Proc’s, Triggers, UDF’s, Constraints, DTS, BCP, Data Compression, Partitioning, Joins, DDL, DML, Cursors, Server Migration, Batch Files etc.

Confidential, Somerset, NJ

Senior MS SQL Server 2008/2005 DBA

Responsibilities:

• As a Production and development support DBA responsible for maintaining 253 SQL Servers out of which 170 servers are production servers in which 100 were mission critical and 70 were business critical servers, remaining test and development servers.
• Installed SQL Server 2008 and SQL Server 2005 on windows 2003 and 2008 servers, applied service packs and security fix for all servers.
• Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.
• Implemented transactional replication for data refresh
• Managed all Publisher, Distributor and Subscriber database environments for the replication
• Experience in upgrading from SQL Server 2000 to SQL Server 2005 servers.
• Upgraded server from MS SQL Server 2005 to MS SQL Server 2008
• Implemented SQL Server Mirroring on SQL 2008/2005 environments
• Created the DTS, SSIS packages to import the data from MS Access and Oracle server to SQL Servers.
• Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)
• Created Data Flow’s for Aggregate, sort, lookup, merge, union all and fuzzy lookups.
• Used containers for repetitive control flow tasks
• Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS
• Scheduled package execution in SSIS
• Installing packages on multiple servers in SSIS
• Extensively worked on SSIS for data manipulation and data extraction, ETL Load
• Created extensive reports using SSRS ( Tabular, Matrix )
• Installed, configured and maintained MS SQL Fail over clustering to provide server high availability solution for 6 different environments.
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Involved in setting up transactional replication in production environment.
• Created the standard documents for Disaster recovery testing and implemented them.
• Experienced with database sizing and capacity planning for production servers.
• Experienced with creating logical and physical database design for development projects.
• Experienced with improving SQL Server using windows performance monitor to improve the server performance.
• Involved in securing the SQL Server environment and involved in setting up the user permissions.
• Experienced with creating database maintenance plans for efficient operations.
• Created the backup schedule for production, test and development servers.
• Worked with developers to do the database schema changes and database restore requests.
• Involved in restore operations to refresh the data from production to test servers.
• Experienced in troubleshooting production servers and fixed the user and application issues.

Environment: MS SQL Server 2008/2005, Windows 2000/2003/2008 Server Operating systems, SSIS, Windows Cluster Server, Windows Server 2003, SQL Server Management Studio, Query Analyser, SQL Profiler, Performance Monitor, SSIS, Team Track.

Confidential, New York, NY

SQL Server DBA

Responsibilities:

• Upgraded most of SQL Server 2000 to SQL Server 2008 R2
• Involved with upgrade of databases from in a Clustered environment.
• Worked on SQL Server 2005 with latest Service Packs.
• Involved in Performance Tuning on Production, QA and Staging servers of the current project.
• Involved in Monitoring Performance of different production servers.
• Implemented Database mirroring for disaster recovery.
• Maintained various databases for Production and Testing using SQL Server 2005.
• Planning the location of data, index, and Transaction log files on the disk.
• Performance tuning, and optimization of procedures and queries.
• Worked with SQL server Profiler.
• Created the backup and restore strategy for production and development environment.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Experience in creating and executing SQL Server Integration Services (SSIS) packages.
• Managing schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them.
• Performing fine Tuning of Database Application. Cleansing and solving Database troubles.
• Used BCP and Bulk Insert utilities and Worked with SQL Server Reporting Services (SSRS).

Environment: MS SQL Server 2008 R2/2005/2000, Windows Server 2003/2000, Vmware, RedGate, SSIS, SSRS, SSAS, Clustering, Mirroring, Log Shipping, Replication