SUMMARY

• 10 plus years of experience in IT as a MS SQL SERVER Administrator/Developer managing SQL environments 24x7 hosting different versions of MS SQL from SQL 7.0 to SQL 2014 on WINDOWS build (Clustered & non - clustered builds) platforms
• Expertise with handling installation/upgrades/migration projects, applying service packs, hot fixes and any security patches applicable to keep systems up to date
• Implementedand supported different High Availability & Disaster Recovery scenarios like Clustering, Replication models, Log Shipping and Mirroring.
• Strong production experience in managing MS SQL Server clustered environment for mission critical systems
• Experience supporting Microsoft Dynamics ERP and BizTalk Servers environments
• Designing and implementing Backup/Restore Strategies for teh SQL Server databases.
• Experience handling large databases from 100GB to over a TB, supporting very large and highly transactional databases and troubleshooting various performance bottle necks on different environments
• Strong DBA/Development skills writing T-SQL scripts, Worked extensively on ETL process using DTS, SSIS packages, handling data quality issues and generating various types of reports using SSRS based on Relational and OLAP databases.
• Administered SSRS Services installation, security, backups and recovery
• Identified, resolved database locks & h/w -related issues, Client/Server connectivity, Query Optimization using DMV’s & Functions, Profiler, perfmon, DTA where necessary, Performance slow-downs due to locks, blocking, index issues and Database Consistency Checks etc.
• Extensively worked on 32 bit, x64 bit clustered & standalone server environments.
• Good understanding of Active Directory, Kerberos, Clustering, SAN's in an enterprise environment
• Knowledge and experience using PowerShell scripting to manage server tasks.
• DATA MODELING using Erwin, designing databases by implementing logical and physical modeling.
• Experienced in using third party backup tools like SQL Safe, DBArtisan, Tivoli & Lite Speed.

TECHNICAL SKILLS

OPERATING SYSTEMS: Windows Server 2000/2003/2008/ R2, Windows NT/XP/98/7/Vista, UNIX, Linux

RDBMS: MS SQL Server 7.0/2000/ / R2/2012, Oracle 8i/9i, MS Access, DB2

TOOLS:, GUI&IDE: DTS/SSIS, SSRS, Crystal Reports 9/10, IIS, SSAS, Erwin, NetLib, Quest LiteSpeed, SQL safe, SQL Compare, DBArtisan, VERITAS Net Backup, RMAN, OEM, Toad, VSS, BizTalk, Microsoft Dynamics AX, BMC Patrol, GPIntegration Manager, Remedy, HP Service Center, SAP, SharePoint 2007/2010, PowerShell 2.0, HPSM, Autosys, i3, TFS 2010, ServiceNow, JIRA, Tivoli (TSM/TDP), ESX VMware…

PROFESSIONAL EXPERIENCE

Confidential, HOUSTON, OK

Sr. DBA/ Security Analyst

RESPONSIBILITIES:

• Actively involved on yearly Audit compliance work for multiple Business units with in Confidential
• Audit involves making sure all Database Servers and any related Application/Web Servers are compliant to teh Confidential defined Controls standards
• As part of User management review, Analyzed all teh Database and Server level roles access review and thus helped in implementing granular SQL Server security to Users, Applications and Websites.
• Created and provided teh Business teams with Dashboard results for teh controls standards and worked on remediation plans as necessary with corresponding teams to make sure all servers are in compliance
• Worked with Release Management and Infrastructure teams in remediating changes as necessary
• Part-time involvement in providing teh operational support as well for various Confidential BUs supporting large-scale Database and ETL environments.

ENVIRONMENT: MS SQL 2008/2012, BI (SSIS/SSRS/SSAS), Remedy, SCOM, Windows 2003/2012

Confidential, BARTLESVILLE, OK

Sr. DBA / Project Analyst

RESPONSIBILITIES:

• Planning and hands-on with database upgrades from SQL Server (2000, 2005) to SQL 2012 involving over 2500 databases and maintaining teh enterprise wide SQL Server Instances on Windows operating systems including development, test and production
• Fallowed teh MS standard upgrade process guidelines and resolved any upgrade compatibility issues with code or applications and thus coordinating with teh involved teams to resolve teh issues
• Coordinates project activities to multiple business and application teams involved with an emphasis on quality and meeting timelines, ensuring successful implementations
• Collaborate with teh application and infrastructure teams in solving any database level issues including availability and stability of teh database environments.
• Worked with Informatica DEV team, assisting with any issues on DTS conversion to Informatica 9.5.1
• Resolve incidents moderate to complex(P1,P2,P3) and problems TEMPeffectively and in timely manner providing 24X7 production support and available for escalation.
• Managing all teh database activities required to support teh releases of new applications to production
• Troubleshoot SQL service outages as they occur, including after-hours and weekends in an on-call rotation
• Administered Reporting Server, including installation, security and backup, recovery

ENVIRONMENT: MS SQL SERVER ( ), DTS/SSIS, SSRS, TFS, Service Now, DBArtisan, SQL Compare, SCOM, Windows ( R2)

Confidential, TULSA, OK

Sr. SQL Server DBA/BI Analyst

RESPONSIBILITIES:

• Responsible for database support, troubleshooting, planning and migration project which involved guidance and adherence to standardized procedures for data center migration from Dollar-Thrifty to Confidential data-center
• Worked with application teams to meet corporate milestones for database consolidation & data migration.
• Configured Transactional Replication across Confidential data centers as well as account management and troubleshooting with connectivity, security and firewall issues.
• Installations of SQL 2008R2/2012 enterprise 64bit version on windows 2008R2 enterprise clustered servers
• Provide all database admin and support tasks within DEV, QA, Production and DR environments
• Maintained, developed, migrated and deployed SSIS packages and handled various data quality issues
• Performed production support and on call duties, fallow teh change management process
• Experienced supporting & managing VM hostedSQLinstance’s on Windows 2003/2008 R2 EE environment
• Migrated physical servers to a virtualized environment built on VMware ESX clustered infrastructure.
• Created and scheduled maintenance plans, migrates teh SSIS packages to newly built servers, created scripts to alert for production issues.

ENVIRONMENT: SQL 2005/2008R2/2012, SSIS, TFS, ServiceNow, DBArtisan, Windows 2008 R2/2003

Confidential, TEMPE, AZ

Server Administrator (MS SQL/ERP/Windows)

RESPONSIBILITIES:

• SQL Server 2008 R2/2012 installations and maintenance in a 24x7 environment, setup production/test/dev environments for multiple databases on DH2i cluster farms.
• Provide all database admin and support tasks for reinsurance within DEV, QA & SANDBOX environments
• Installed and configured BizTalk 2009 product/Microsoft AX2009 modules on all environments
• Generated reports using AX and SSRS
• Capacity planning for teh primary assigned servers to ensure adequate CPU, Disk space and Memory
• Fine-tuning and trouble shooting for day to day problem or issue raised by development team
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration, disaster recovery, database consistency check, rebuild indexes, and update statistics.
• Installed and configured Windows server 2012 domains in an enterprise network environment
• Administered Windows servers Active Directory, including Group Policy, creation and deletion of user accounts, managing access controls, and domain structure configuration.
• 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 environments.
• Implemented disaster recovery solution at teh remote site for teh production databases using mirroring

ENVIRONMENT: SQL, MS Dynamics, Windows, DH2i Clusters, NetBackup, HPSM

Confidential, CHARLOTTE, NC

MS SQL Server DBA

RESPONSIBILITIES:

• Managed 200 plusSQLServers (2000, 2005, 2008, 2008R2) with team of 6DBAs in 24x7 production environment, provided on-call & day-to-day support.
• Database Administration for all databases (Production /Development/UAT), with day to day tasks includes database monitoring, Backups, Space Management, Resource Utilization on servers.
• Installing/managing/troubleshooting SQL Server 2005/2008 clusters (2-node and 3-node clusters)
• Responsible for primary database upgrade of production, test and development database from SQL 2005 to SQL Server 2008 R2 and gathering upgrade pre dependency and post dependencies checks.
• Monitoring and making recommendations for performance improvement in hosted databases which involved index creation, index removal, index modification, file group modifications, code optimization and adding scheduled jobs to re-index and update statistics in databases.
• Conducting database refresh from PROD to UAT, DEV, and Test Environments.
• Worked on problem management, and companies internal tool for change control process

ENVIRONMENT: SQL Server 2008R 2/2008/2005/2000 , Windows 2008 R2/2008/2003, LiteSpeed

Confidential, RICHMOND, VA

SQL Server DBA/BI Developer

RESPONSIBILITIES:

• Managing 400+SQLServers (2000, 2005, and 2008) with more TEMPthan 3000+ databases providing 24x7 support for SQLServers with team of 11DBAs.
• Installation of teh SQL Server 2008 on new Production and Test servers with latest Security updates involving Service Packs and Security patches.
• Performing administration tasks on teh live databases like re-indexing, shrinking databases, rebuilding full text catalogs. Applying Database Upgrade Scripts comprising various Model changes and updated database objects as requested by teh client in accordance with teh Software Builds and Service Packs.
• Performed compression of historic data and backups to reduce amount of space it takes on disk.
• Created Partition function, Partition scheme and multiple file groups and files to host teh table data (consists of over 250 million rows) for Data partitioning.
• Used TFS for version control, source code check-in
• Experience working with Autosys to automate jobs, change status of job, job recovery, running DTS and SSIS packages in different environment of teh life cycle.

ENVIRONMENT: SQL Server 2000/2005/2008 R2, Windows 2008 R2/2000, Autosys, TFS, DTS/SSIS

Confidential, TAMPA, FL

MS SQL Server DBA

RESPONSIBILITIES:

• DBA with responsibilities included: installations, migrating, creating and monitoring maintenance plans, creating database objects, query optimization, and job development and monitoring
• Performed SQL Server version upgrades to 2005/2008 and migrations & deployed changes to production databases. Create and maintain technical documentation and implement database related policies.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 with teh help of migration techniques like Package Migration Wizard, SQL Server Package Migration Advisor, Execute DTS 2000 Package Task.
• Performed day to day Database Maintenance tasks - Database Monitoring, Backups, Space Management, Resource Utilization, responsible for performing object migration between all production database Servers.
• Troubleshoot database performance issues and tune database objects. Set up traces and Profiler to troubleshoot performance issues. Analyze deadlocks & diagnose issues on teh server.
• Configured Mirroring on our newly migrated servers, Architected and configured transactional replication one publisher and two subscriber’s environment for production servers.
• Designed ETL strategies to pull data from different sources like SQL Server, oracle, flat files and load it to teh destination database after using multiple transformations.
• Troubleshoot Infrastructure issues related to SQL database server such as memory, I/O, Disk, etc. Monitor log files to proactively resolve issues. Perform vulnerability checks and did patch upgrades.

ENVIRONMENT: SQL Server 7.0/2000/, Windows 2008/2003/2000 , DTS/SSIS

Confidential, RIVERVIEW,FL

MS SQL Server DBA/BI Developer

RESPONSIBILITIES:

• Installed and Configured SQL 2005 on production environment and Upgraded/Migrated SQL Server 2000 Servers to SQL Server 2005 on cluster & non cluster environment which also included move to new SAN and servers running on Windows 2008 servers, On call 24/7 support to databases on weekly rotation.
• Configured Active\Passive 2 node Clusters on windows 2003 with SQL Server 2005, Troubleshoot issues within a clustered server configuration.
• Created Linked Servers on SQL 2000/2005 servers to migrate data from Oracle database to SQL databases.
• Implemented HA/DR solutions include configuring Log Shipping, Transactional & Merge replications.
• Day- to - Day Monitoring of teh event logs and server logs for troubleshooting & automating jobs on server
• Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans Set Statistics IO, Profiler and Execution Plans.
• Involved in migrating application form DB2 8 to SQL Server 2005
• Partitioned data across SAN volumes as well as individual database file groups for performance boosts
• Responsible for managing Windows 2003/2000 servers in an Active Directory environment including domain controllers, DNS, Group Policies, web server issues and server security in a multi-data center environment
• Maintaining both DEV and Test servers in sync with PRODUCTION server by doing Database Refreshes.

ENVIRONMENT: Windows 2003/2000, SQL Server 7.0/2000/2005 , DTS/SSIS/SSRS, LiteSpeed, VMware

Confidential

T-SQL/.NET Developer DBA

RESPONSIBILITIES:

• Developed Web sites for ecommerce, extranets and intranets using ASP, SQL and XML
• Wrote custom T-SQL store procedures and triggers to improve performance, preserve referential integrity and provide additional application functionality
• Transformed logical data models into physical database structures and defined appropriate constraints
• Created DTS/SSIS packages to import teh data from Oracle, Access and text files to SQL server
• Responsible for deploying reports to Report Manager & Troubleshooting errors occurred in execution
• Installed configured and maintained Dev/Test/staging servers and performed all administration tasks including backups, availability monitoring, disk space management, performance management, and data archiving.
• Implemented enhanced availability techniques and created a mirrored database on teh report server using Database Mirroring with high performance mode.
• Create teh cluster/non-cluster indexes on teh tables, created views, stored procedures, and triggers.
• Responsible for change managements, documenting for SQL Server & ETL packages deployment
• Supported high traffic e commerce application, where teh traffic use to hit more TEMPthan 100GB of data on a peak day & troubleshoot network issues with teh connection
• Worked at windows registry level to resolve SQL Server failed installations.

ENVIRONMENT: MSSQL (7.0-2005), DTS/SSIS/SSRS, IIS, TFS, ASP, PL/SQL, Windows 2000/NT/2003