SUMMARY:

• Over 5 years of Database Administration for very large databases in SQL Server 2008 R2, 2008, 2005 and 2000.
• Experienced in Installation, Configuration, Maintenance and Administration ofSQLServer 2008R 2/2008/2005/2000/7.0 in standalone environments.
• Hands on experience wif administering large to very large databases wif sizes up to 1.3 TB.
• Expertise in T - SQL skills in creating tables, storedprocedures, views, Indexes, triggers, user defined data types and functions.
• Maintained individual service accounts for SQL Server services on cluster wif different Security groups to raise security mark.
• Migration from SQL server and 2000/ /2008R2 by using In - place as well as side - by-side upgrade process wif detailed documented upgrade process.
• Intensive experience in monitoring, optimizingand tuningSQLServerdatabase performance.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Experience in Auditing of database for users transaction, login and database action and removing orphan users.
• Expertise in using DBCC trace flags, handling blocking and dead lock situations.
• Handful of Experience on SQL server features like data compression, performance data collector and resource governor.
• Expertise in performing data transformations between servers using DTS, SSIS and bulk insert.
• Experience in configuring Database Mail, Operators and alerts on large scale systems.
• Good at Data availability solutions like online index operation, database snapshot, and resource governor.
• ExperienceinRebuilding and Reorganizingindexes for better performance.
• 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.
• Worked on configuring SQL Server wif minimum privilegedaccess.
• Experience in implementing SQL Server security and Object permissions like maintaining Database autantication modes, creation of users, configuring permissions and assigning roles to users

TECHNICAL SKILLS:

Databases: MS SQL Server 2008, 2008R2, 2005, 2000

DBA: Database Administration of MS SQL Server 2008,2008R2, 2005, 2000

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

Tools: Backup Utility, SQL LiteSpeed, Idera, Patrol, RedGate SQL Compare, Redgate Source Control.

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

PROFESSIONAL EXPERIENCE:

Confidential, Richfield, oh

SQL DBA/Deploy Analyst

Responsibilities:

• Installed and configured SQL Server 2005/2008/2008 R2/2012 Enterprise/Standard edition in teh Production/QA/DEV environments.
• Administered SQL Server Instances running on 2005/2008/2008 R2/2012 across DEV, QA and Production environments.
• Worked on upgrading SQL server instances and applyingservice packs and hot fixes.
• Ensured company best practices for any and all SQL Server related items.
• Use RedGateToolbelt for Database backups, Schema compare and Data compare.
• Install/DeploySSIS, SSRS and SSAS as well as troubleshoot these services across different environments.
• Involved in Extensive Deployment and coordination process to deploy SQL Scripts, RDL report files andSSIS, SSAS and SSRS.
• Streamlined teh server/database level security by creating teh Windows and SQL logins wif teh appropriate server/dbroles and object level permissions.
• Monitoring of database size and disk space in Production, Staging & Development environments.
• Participate in implementation of new releases into production.
• Backup and restore backups to Development and QA environments on request from development teams and LOB.

Environment: Windows server 2003/2005/2008/2012, MS SQL Server 2012/2008R2/2008/2005, TFS 2008/2013, RedGate SQL Compare, TortoiseSVN.

Confidential, KANSAS CITY, MO

Database Administrator

Responsibilities:

• Installing, configuring and monitoring SQL 2000/ 2005/2008/2008 R2 instances.
• Monitoring of databasesize and diskspace in Production, Staging&Development environments and when needed co-ordinate wif SAN administrators to mount extra storage to disks.
• Restore backups of production servers to a test server to check teh integrity of teh backed up databases.
• Backup and restore backups to Development and QA environments on request from development teams and LOB.
• Participate in CAB meetings on behalf of DBA team every week to discuss about all teh changes that are taking place for teh given week.
• Verify each server in all environments to see they adhere to Installation checklist, if they don’t meet guidelines tan re-configure such that they meet all guidelines.
• Standardize Data, Log and Backup files locations on all servers and move files across different drives if necessary.
• Monitored Jobs failures and fixed teh issues when needed.
• Participated in resolving tickets (incidents, requests and change tasks).
• Coordinated and Involved in weekend Deployments wif development teams and LOB.
• Finding and fixing Orphan users across all databases.
• Adding new users by coordinating wif various departments (IP Reservations, Active Directory and Firewall).
• Restricting access to roles and users to various objects wif different set of permissions.
• Used BMCPatrol as monitoring tool.
• Creation and scheduling of Maintenanceplans (database and log backups and cleanups)Rebuildindex/updatestatics for better performance of teh databases.
• Experience in using PerformanceMonitor, SQLProfiler and optimizing teh queries, tracing long running queries and deadlocks.
• Executed Change management scripts on weekly basis.
• ScheduledFull and Transactionallog backups for teh user created and system databases in teh production environment using teh DatabaseMaintenancePlanWizard.

Environment: SQL Server 2000\2005\2008\2008 R2, Windows 2003\2007 Server, BMC Patrol.

Confidential, Boston, MA

Junior SQL DBA

Responsibilities:

• Installing, configuringSQLserver 2008 R2 instances.
• Involved in database design. dis involved converting Non-Relational database to Relational database (i.e. converting from ADABAS to SQL).
• Created Schemas for enabling role based access of SQL server objects.
• Provided optimal database backup strategy layout for utilization of storage and performance acceptable to client.
• Automated various SQL Server Jobs that involved collecting data from various agencies.
• Creating and Reviewing Security features for all teh servers.
• Working on SQL server audit for DDL and DML changes performed on teh database.
• Configured various roles to limit access to database.
• Planned, executed and documented database Migration fromSQL Server R2.
• Performed database mail configuration, partitioning, and shrinking, registering operator for email notifications.
• Usedimport and export data wizard, Bulk Insert, Generate scripts from various sources to objects in database.
• Implement Data Compression for high performance of SQL Server on various situations
• Monitored jobs, backups, server stats, server ping, SQL server permissions and SQL Safe for backups using encryption
• Implemented Database Mirroring wif witness server as a High Availability option.
• Configuring Alerts, maintenance plans for backing up teh database, Rebuildindex/updatestatics for better performance of teh databases.
• Monitoring SQL server LOGS, Application logs (Event Viewer), Tuning SQL server databases using SQLProfiler, Performance monitor, database tuning advisor.
• Handled Fine Tuning Operating System in-coordination wif Server and Network Administrator to utilize teh maximum resources for Database and Applications.

Environment: ADABAS, SQL Server 2008R2, Oracle 10i, Subversion, Microsoft One Note, SQL Server Profiler, Visio 2007.

Confidential, Los Angeles, CA

Junior SQL DBA

Responsibilities:

• Involved in database administration, database development, database design and databaseRelease Management.
• Created documentation for steps undertaken while migrating SQL 2005 to SQL 2008.
• Extensively used database upgrade advisor during migration process.
• Planned and implemented high availability technique using database mirroring on user databases on SQL server 2008.
• Monitoreddatabase mirroring by creating performance alerts and mirroring status alerts.
• Implemented SQL server audit for Payments and Beneficiary tables so as to maintain confidentiality.
• Created documentation which is a step by step guide to Implement/TroubleshootDatabase Mirroring.
• Implementation of SQL Logins, Roles and Autantication Modes as a part of Security Policies for various categories of users.
• Rebuilding teh indexesat regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Monitored and modified Performance usingexecutionplans and Index tuning.

Environment: Windows bit, SQL Server 2005/2008, Database Mirroring, T-SQL, Subversion, Profiler.