SUMMARY

• Over Eight years of IT experience in SQL Database Administration, System Analysis, Development, Support of MS SQL Servers 2005,2008,2008R2 and 2012 in Development, Production, QA environments, Replication and Cluster Server Environments.
• Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2005/2008/2008 R2/2012.
• Experience in upgrading SQL Server from version 2008R2 to 2012.
• Good experience with SQL Server 2005 online Indexing and Recoveries features.
• Good experience with implementing DR solution, High Availability of database servers using Database mirroring and replications and Log Shipping.
• Experience in implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Created maintenance plans to perform index de - fragmentation, re-indexing and update the index statistics.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
• Experience in Data Migration Management.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor(DTA).
• Recovering the databases from Backup In Disasters.
• Scheduling of maintenance JOBS (Daily, Weekly, Monthly) as per the client request.
• Administrating high availability solutions like Log shipping and Database Mirroring.
• Identifying and resolving Blocking and Deadlocking issues by using Activity Monitor, System stored procedures and Profiler.
• Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
• Experience in applying patches and service packs to keep the database at current patch level.
• Experience in migrating packages from DTS to SSIS.
• 24 X 7 Production Database on Call Support

TECHNICAL SKILLS

Operating Systems: Windows 2003/2008 Server, Windows98/XP/NT/7,Linux

Databases: MS SQL Server 9,10,10.50,11 Oracle10g/11g

Languages: T-SQL, PL/SQL

SQL Server Tools: Management Studio, Business Intelligence Development Studio, Visual Studio 2005, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, DTS, Log Shipping, Server Network Utility, Database Tuning Wizard, Index Tuning Wizard, SSIS, SSAS, SSRS.

Report Tools: MS Reporting Services, SAS

Data Migration: MSDTS, SSIS, BCP, Data Migration, SQL Loader, Import/Export Wizard Database Modeling

IDE Tools: IntelliJ Idea, Eclipse, FileZilla, Putty

PROFESSIONAL EXPERIENCE

Confidential, Ann Arbor, MI

Sr. SQL DBA

Responsibilities:

• Installing, configuring, administrating and securing SQL Server 2008/2008R2/2012.
• Administrating databases in SQL Server 2008R2/2012.
• Migrated databases from SQL Server 2008R2 to SQL Server 2012.
• Performing all types of Backups such as Full, Differential and Transaction log backups.
• Maintained Alert Notifications, Jobs, and Schedules.
• Heavily used Transactional Replication, Configured Transactional replication between Primary Server and Read - Only servers and experience in troubleshooting replication problems.
• Scheduling and monitoring all maintenance activities including database consistency check, update statistics, and index maintenance.
• Handling database fragmentation related issues.
• Scheduling Jobs in SQL server.
• Verifying backup jobs.
• Moving data using Export and Import wizard, BCP and Bulk-Insert.
• Creating Maintenance plan for database consistency checks and update statistics.
• Identifying and resolving Blocking and Deadlock issues by using Activity Monitor and Profiler.
• Solving space issues like TempDB and Log file issues.
• Monitoring server performance.
• Extensively worked on DBCC commands and Dynamic Management Objects.
• Expertise in SQL Server Reporting Services and SQL Server Analysis Services.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Complete documentation about the database. Recovering the databases from backup in disasters.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• To set up SQL Server configuration settings for better server management.
• Monitoring the servers using Idera third party software
• As a part of the DBA team providing 24/7 production support to the clients.
• Designed and implemented comprehensive Backup plan using SQL LiteSpeed.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Resolved and tweaked memory pressures caused during product release.
• Worked with customers on Application rollouts and server migrations.
• Troubleshoot performance problems and fine-tuning of databases.

Environment: SQL Server 2012, SQL Server 2008R2, Windows 2008/2003 Server, SQL LiteSpeed 8.1, MSE, ME Change Request, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler and SSMS.

Confidential, Wayne, PA

Sr. SQL DBA

Responsibilities:

• Installing, configuring, administrating and securing SQL Server 2005/2008/2008 R2
• Monitoring of database size and disk space in Production, Staging & Development environments
• 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.
• Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.
• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
• Configured Database mail, linked servers in SQL server 2008.
• 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.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS packages.
• Migrated Databases from MySQL, Oracle, Confidential Informix, to SQL Server 2005.

Environment: SQL Server2008R2,SQL Server 2008,SQL Server 2005, Windows 2008/2003 Server, SQL LiteSpeed, MSE, ME Change Request, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler and SSMS, Windows 2008/2008R2 Servers, T-SQL, Oracle PL/SQL, MySQL, Oracle 9i, PL/SQL Developer Tool.

Confidential

SQL DBA

Responsibilities:

• Installing, configuring, administrating and securing SQL Server 2005/2008/2008 R2
• Monitoring of database size and disk space in Production, Staging & Development environments
• Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.
• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
• Configured Database mail, linked servers in SQL server 2008.
• 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.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS packages.
• Migrated Databases from MySQL, Oracle, Confidential Informix, to SQL Server 2005.
• Experience on high availability solutions including log shipping & Mirroring.
• Granting various database level & server level permissions to users.
• Creating logins, users, databases and roles.
• As a part of the DBA team providing 24/7 production support to the clients.
• Monitoring the server for High availability of the servers.
• Solving the request raised by user support.
• Participate in implementation of new releases into production.
• Facilitates application deployment and joint effort deployments.
• Day-to-day administration of live SQL Servers.
• Designed and implemented Security policy for SQL Servers.
• Used Stored Procedures, DTS packages, BCP for updating Servers.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.
• Automated messaging services on server failures, for task completion and success.
• Execute procedures to accomplish short-term business goals.
• Deploying Administration tools like SQL DB Access, Performance Monitor and Backup Utility.
• Table partitioning to improve I/O access.
• Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users.
• Using database level triggers code for database consistency, integrity and security.
• Tested and Implemented procedures to detect poor database performance, collecting required information, root cause analysis.

Environment: SQL Server2008R2,SQL Server 2008,SQL Server 2005, Windows 2008/2003 Server, SQL LiteSpeed, MSE, ME Change Request, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler and SSMS, Windows 2008/2008R2 Servers, T-SQL, Oracle PL/SQL, MySQL, Oracle 9i, PL/SQL Developer Tool.

Confidential

SQL DBA

Responsibilities:

• Hands on experience in installing, monitoring and troubleshooting SQL Server 2005, 2008.
• Experience in applying service packs.
• Hands on experience in upgrading SQL Server (from ).
• Configuring and implementing jobs and alerts.
• Scheduling backup jobs using third party backup tool.
• Performance monitoring and tuning.
• Experience on high availability solutions including log shipping & Mirroring.
• Granting various database level & server level permissions to users.
• Creating logins, users, databases and roles.
• As a part of the DBA team providing 24/7 production support to the clients.
• Monitoring the server for High availability of the servers.
• Solving the request raised by user support.
• Participate in implementation of new releases into production.
• Facilitates application deployment and joint effort deployments.
• Meet the SLA (Service Level Agreement) established.
• Day-to-day administration of live SQL Servers.
• Designed and implemented Security policy for SQL Servers.
• Used Stored Procedures, DTS packages, BCP for updating Servers.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.
• Automated messaging services on server failures, for task completion and success.
• Execute procedures to accomplish short-term business goals.
• Deploying Administration tools like SQL DB Access, Performance Monitor and Backup Utility.
• Table partitioning to improve I/O access.
• Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users.
• Using database level triggers code for database consistency, integrity and security.
• Tested and Implemented procedures to detect poor database performance, collecting required information, root cause analysis.

Environment: SQL Server 2005/2008, Oracle 9i, JavaScript, VSS, Windows 2000, Windows 2003 Server, MS-Access and ant scripts.

Confidential

Junior DBA

Responsibilities:

• 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.

Environment: Windows 2003 Server, SQL Server 2005, SQL Server 2000,T-SQL, PL/SQL, Erwin 4.1, JavaScript, MS IIS Server 5.0, SOAP, HTML/DHTML, XML, Oracle8i.