OBJECTIVE:

A position utilizing my extensive Sr. Database Administrator experience, IT Service Management experience, System Administration experience, my record of accomplishments and help me grow as an efficient Leader and as a Senior Database Administrator.

SUMMARY:

• Completely revamped Deployment process and reduced environment inconsistencies across multiple environments
• Outstanding communication and interpersonal skills
• Key team member who contributes positively to each project; works well in high stress situations
• Organized, efficient, productive, punctual, dedicated, hard worker, goal and results - oriented

TECHNICAL SKILLS:

RDBMS: MS SQL SERVER 2000/2005/2008/2008 r2/2012, Analysis Server 2008/2008r2, MS Access 2000/2005.

Databases Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), Database Engine Tuning Advisor, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, MS Visio, SSRS, SSIS, SSAS

Programming Languages: SQL, TSQL, XML, PL/SQL.

Web Tools: MS-Front Page, Internet Information Server(IIS),FTP,TCP/IP,LAN,MS-Outlook Express

Operating Systems: Windows 95/98/2000/2003/2008/ XP/NT 4.0, Linux, MS-DOS.

Utility Tools: MS Office

PROFESSIONAL EXPERIENCE:

Confidential, Winston Salem, NC

Responsibilities:

• Execute database requests for production and staging environments
• Ensure all scheduled administrative jobs are running/completed for daily business cycle on Microsoft SQL Server
• Schedule and monitor Database Backups through SQL Server 2012,SQL Server 2008 R2
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and AAG.
• Implemented AlwaysOn High availability(Availability groups)
• Implemented Database mirroring
• Implemented 2 node failover clustering
• Work with development teams for design and writing/tuning SQL
• Implemented Transparent Data Encryption in Test, Staging, UAT and Production environments
• Implemented Change Data Capture in Test, Staging, UAT and Production environments
• Work with marketing team, gathered the requirements for the Reports (SSRS,SSIS and SSAS)
• Tuning databases by creating Indexes, Updating Statistics and performing Index defragmentation and troubleshoot slow running queries
• Monitor the databases continuously with third party tools like Ignite confio, SQL Monitor and SQL Idera
• Compare and Refresh databases with tools like SQL Compare and SQL Data Compare (RedGate)
• Identify high CPU, network contention queries and assist developers with tuning queries
• Establish linked server between Mas90x (providex database) and SQL Server 2005
• Upgrade SQL Server 2008 to 2008 R2 on test, staging and production environments
• Upgrade SQL Server 2008 R2 to SQL Server 2012 on test, staging and production environments
• Upgrade/Migrate strategies from earlier/legacy version to MS SQL Server 2008 using suitable methods
• Created SSIS packages and deploying using Package Configuration along with Deployment utility
• Deploy builds on Test, development and Production environments
• Automated the deployments with batch scripting, wscript and PSExec

SQL Server DBA

Confidential, Columbia, SC

Responsibilities:

• Execute database requests for development, test and production environments based on the tickets from JIRA
• Schedule and monitor Database Backups through SQL Server 2008 and SQL Server 2005
• Schedule and monitor Servers through Symantec backup exec 12.5
• Administration including Planning, Installation, Deployment/Implementation, Advanced Configuration of MS SQL Server 2008/2005 (Clustered/Non-Clustered) as per Microsoft Operation Framework (MOF) guidelines
• Upgrade/Migrate strategies from earlier/legacy version to MS SQL Server 2005/2008 using suitable methods
• Install and configure SQL Server 2008 in Windows Server 2008 Clustered environment
• Implement Recovery and Backup Strategy, Log Shipping, Database Mirroring and snapshot for Disaster Recovery and reporting purpose.
• Assist developers on demand with coding DDL using CA ERwin and DML via command line and GUI tools
• Analyze performance over time and find and fix performance bottlenecks using SQL Idera
• Assist migration team with Loading legacy data from mainframe systems using SSIS packages, BCP
• Automated the build releases/deployments using scripting technologies like VBScript, JavaScript and shellscripting
• Work with SQL Server management studio (SSMS) and Business Intelligence Development studio (BIDS) for SQL Database Engine, SSIS and SSRS.
• Using DMV’s for performance analysis and Implementing Index Rebuild process for performance improvements based on Built-in SSMS reports.
• Using Database Engine Tuning Advisor, SQL Server Profiler and other tools for trace Analysis.
• Work in cooperation with developers/project team for achievement of efficient database access and resource usage for applications. This includes activities like designing, adding, eliminating, or maintaining indexes/re-organizing tables, recommending SQL configuration changes to application teams
• Set up Replication for Development and QA Environment.
• Design of Performance Tuning and Maintenance plan for consistency checks, backup/restore strategies and Indexes.
• Optimize various objects like Stored Procedures, triggers, views and implementing performance improvement issues using Query Analyzer, Profiler and Index Tuning Wizard.
• Deploy and maintain application build components for various environments
• Configure and optimize NAS/SAN with different RAID levels
• Technical support to users for various purposes like storage space managements on RAID/SAN drives.
• Configure LUN’s to the servers(physical/virtual) associated with the SAN
• Create virtual machines

Technologies:

• VMware administration with ESX 3.5
• Virtual Center 2.5
• Design and implement SCOM 2007
• Administer SQL Server 2008, SSRS 2008, Red Gate (SQL Compare 8 and SQL Data Compare 8)
• Symantec backup exec 12.5
• Administer Share point
• IIS 7.0
• Work on SFTP
• Automate deployments
• LetterGenie for reports and forms deployment
• Windows 2008 Server/Advanced Server, 2008 Standard, Enterprise R2, and Web Edition: Installation, configuration and troubleshooting including: OS build, NLB, Microsoft Clustering Services and Security Configuration (SCW)
• Implement Release management, Change control and Configuration Management
• Work with Application architects on implementing the solution with in the environment constraints
• Work with Microsoft visio 2003/2007

System and Database Administrator (SQL Server)

Confidential, Dublin, OH

Responsibilities:

• Installed and configured of SQL server 2005, Windows Server 2003 Enterprise Edition, IIS 6.0
• Schedule and monitor Database Backups through SQL Server 2005
• Executed, configured and tested batch jobs for Interfaces
• Profiled memory and processor utilizations for performance testing
• Managed security logins and worked with Windows authentication, SQL server authentication and mixed modes
• Worked intensively on granting and revoking rights, privileges to users and worked with user roles
• Documented and maintained software installation and application issues and their resolutions
• Developed, deployed and monitored SSIS Packages
• 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
• Developed and optimized database structures, stored procedures, views, triggers and user-defined functions.
• Deploy .msi files and .dlls on multiple environments; install web components
• Implement Change control and Configuration Management
• Work with Application architects on implementing the solution with in the environment constraints
• Plan and execute Non-functional testing like System security, Application security, Failover, Recovery etc
• Patch management
• Deliver Operations Manual, evaluate new products and provide recommendations to the client
• Provide status updates to the HP management and Client on a frequent basis
• Capacity planning and providing recommendations on DB Sizing
• Performance tuning recommendations from a Server utilization perspective

Technologies:-

• VMware administration with ESX 3.5
• Virtual Center 2.5
• Design and implement SCOM 2007
• Administer SSRS 2005, SSRS 2008, SQL Server 2005, SQL Server 2005
• Administer TFS 2005
• Work on SFTP
• Automate deployments
• Citrix Administration
• STT Trainer 5.5
• Hardware and Application: Installation and upgrade Corporate Anti-Virus
• Implement Change control and Configuration Management
• Plan and execute Non-functional testing like System security, Application security, Failover, Recovery etc
• Work with Microsoft visio 2003/2007

Database Engineer

Confidential

Responsibilities:

• Worked extensively on installation, upgradation and configuration of MS SQL Server 2005 databases/ servers.
• Actively participated in gathering of User Requirement and System Specification
• Involved in migrating databases, DTS packages from MS SQL server 2000/2005
• Solved various issues (Tickets) encountered in migrating from SQL Server 2000
• Handled various issues related to the setup and configuration of Log Shipping, Mirroring.
• Implemented transactional replication between Primary Server and Sub Systems.
• Worked with developers to tune the SQL queries using SQL Profiler.
• Worked extensively on Database space management, performance monitoring, Tuning.
• Administered 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 to automate daily DBA activities
• Managed Daily/Weekly/Monthly database administration functions, such as backup/recovery/data management/performance monitoring/tuning/Jobs and Re-indexing.
• Involved in scheduling jobs using SQL Server Agent as required.
• Involved in using DBCC commands for Integrity check.
• Used third party tool lite speed for database backups and restorations.
• Developed DTS/SSIS packages to import the data from MS Access, Oracle server to SQL Servers.
• Extensively used SSIS to move data from text files to SQL Server.
• Designed SSIS packages generated Reports (SSRS) using Business Intelligence Development Studio.
• Involved in handling and downloading data using FTP jobs from Mainframe systems.
• Used Robocopy for moving data from Source to Target paths.
• Developed documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.
• Hands on experience with Change management tickets on Production Box
• Worked as part of the 24 x 7 team which included working over the week-ends and late nights.