SUMMARY

• More TEMPthan 8 years of experience as SQL Server DBA (2012, 2008, 2005, 2000) in Production, Development and Staging, Data Warehouse Environments (OLTP and OLAP
• Extensive experience in Configuration, Implementation and Maintenance for Disaster Recovery solutions Using Log Shipping, Transactional & Merge Replication in SQL Server 2008/2005.
• 24/7 on Call Support for Production Databases.
• Migrated the SQL Server 2008 to SQL Server 2012.
• Migrated the SQL Server 2000/2005 to SQL Server 2012 and 2008 R2 versions.
• Involved in Migrating MYSQL to SQL Server 2008 databases.
• Experience in installing and configuring SQL Server 2012/2008 R 2/2008/2005/2000 SQL Server versions
• Hands on experience and outstanding noledge of high availability SQL Server solutions, including SQL Server Log shipping, Mirroring and SQL Server clustering (Active/Active and Active/Passive.
• Proficient in SQL programming, physical database design, and SQL Performance tuning, replication.
• Used Erwin modeling tool for designing database objects.
• Managed data warehouse d atabases.
• Used PowerShell script for SQL Server Maintenance activities.
• Handled very large databases (OLTP) which are in Terra Bytes (TBs).
• Extensive experience in Deploying and Consolidating Remote Instances.
• Experience in scheduling Backups and Restore, Log Shipping and Maintenance plans using Native & Third - party tools (LiteSpeed5.0 and Red Gate SQL Backup).
• Expertise in Scheduling Database tasks - Jobs, Alerts, Emails, Notification.
• Experience in Configuring and Maintaining Database Mirroring and Database Snapshots.
• Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues
• Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel, Oracle, and Teradata.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Installation and Configuration of Oracle databases 9i/10g.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and partial blocking Transformations.
• Experience in working wif PIVOT topologies for MS Excel wif SSAS 2008.
• Extensive experience in end to end life cycle of SSRS using Scale-Out, Scale-Up and Local topologies.
• Designing and Deployment of Reports for the End-User requests using Web Interface and SSRS (Ad-hoc Reporting).
• Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Enterprise Standards.
• Experience in solving Database issues wif Index fragmentation, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and DB Engine Tuning Advisor.
• Object Level Audits using Change Data Capture (CDC).
• Managing database systems using Query Governor and Activity Monitor.
• Expertise in SQL Server Storage Structures and Security Architecture for databases residing on SAN storage on distributed systems.
• Experienced in programming tasks-Stored Procedures, Triggers, Cursors using SQL Server 2005/2000/7 wif T-SQL
• Implementing efficient Database Design principles including Partitions and Compression techniques.
• Experienced in SDLC life cycle for Design, Development and Staging phases of the projects wif support of Data-Flow, Process Models, E-R Diagrams.
• Good noledge in OOP’s concepts and Business Objects & Database analysis and design experience using Erwin.
• Strong T-SQL Developer skills including stored procedures, Indexed views, User Defined Functions (UDL), Triggers, and Distributed Queries.
• Working noledge of .Net Framework 2.0 (VB.Net, ASP.Net, ADO.Net), IIS 6.0
• Testing methodologies and tools - Automation and Performance testing.
• Strong Communication & Management skills and Excellent Team player.

TECHNICAL SKILLS

Databases: MS-SQL Server 2000/ 2005/2008/2012 , Oracle, MS Access 2003.

Languages: C, C+, T-SQL, VB Script, Java Script, HTML, XML

SQL Server Tools: Management Studio, Enterprise Manager, Index Tuning Wizard, Database Tuning Wizard, Profiler, Query Analyser, Export & Import, Precise i3 for SQL Server.

Operating system: Windows 2008/2003/2000/ Professional/ NT 4.0 Advanced Server

OLAP Tools: SQL Server Analysis Server 2008, 2005, SSIS (as ETL)

Software Packages: MS Office 97/2000/XP, 2003, 2007, MS Outlook 2003, 2007, Visio

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, IA

Sr. SQL Server Database Administrator/Developer

Responsibilities:

• Involved in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 1 Terabytes.
• Created and maintained various databases for Production, Development and Testing environments using SQL Server 2012, 2008r2, 2005.
• Actively involved in setting up Active-Active/Active-Passive clustering in production and Testing Environments and also trouble shooted issues wif the same. Applied hot fixes and Service Packs in clustering environments.
• Conducted Database mirroring in High Performance and High Availability mode and trouble shooted issues wif witness servers.
• Involved in migration of SQL 2005 TO SQL 2008r2
• Performed daily backups and developed recovery procedures
• Involved in the migration of the data across different databases and different servers using SSIS, BCP and Import/export tools.
• Experienced in performance tuning using windows performance monitor and SQL profiler of SQL server. Used SQL Server error logs and event viewer to troubleshoot issues.
• Implemented and configured database monitoring tools and focused on providing a high availability database.
• Troubleshooted issues wif log file full and database size increasing beyond threshold.
• Creation of new database, planning the location of data, index, and transaction log files on the disks
• Involved in Capacity Planning, data modeling and Logical/Physical database Design
• Involved in Change Control Management is the discipline of systematically identifying and controlling change requests to a project from both internal and external sources
• Provided support to the application developers on the application databases
• Handled the database components of application releases
• Handled 24/7 production issues.
• Created various multi-dimensional cubes (SSAS), processed facts, dimensions and populated data for front end users.
• Manage SSIS packages, stored procedures, jobs, and utilize Server Side tracing to identify performance issues wif deadlocks & other locking issues.
• Performed Database consistency checks wif DBCC, Defrag, Index tuning and monitored error logs
• Developed few reports using MS SQL Reporting Services.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Refreshes from Production backup to Stage and Development environments.
• Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting / Ad hoc reporting.
• Worked closely wif development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.
• Extracted data from various sources like SQL Server 2005/2008/2012 , Oracle, Teradata, .CSV, Excel and Text file from Client servers and through FTP.
• Working wif Nexus Tickets (Any changes on staging and development environment need to Create Nexus Tickets)
• Working wif Maximo Change Request(Any changes in Production database need to Create Maximo Tickets dis should be approved by Global DBA team after changes made in stage and development environment)
• Involved in all ITIL process like Change management, Incident Management & Problem Management.
• Developed and deployed stored procedures, created triggers and audits.
• Developed Jobs for maintenance in terms of updating statistics, rebuilding indexes, scheduled full/diff/log backups, refreshing database environments periodically or on demand. Also set up notifications for failure of jobs etc.
• Actively participated in determining the database schema, database schema changes, implementation plan for database schema releases in coordination wif developers and data modelers in adherence wif Organization policies.
• Proactively monitored, determined and solved issues at sql/database/server levels.

Environment: Windows 2003/2008, MS-SQL Server 2012/2008r2/2005, .NET Framework, Visual Studio, i3 performance tool, SSIS and SSRS, Sites Scope monitoring tool, IDERA tool, VMware machines, AJAX, Visual Studio, HTML, XML, XSLT.

Confidential

Sr. SQL Server DBA

Responsibilities:

• Planned and Successfully Installed SQL Server 2005, 2008 on the Production and
• Development Servers.
• Successfully Installed the Service Pack 2 and Hot-fix for SQL Server 2005 in all the Dev and Prod Environments.
• Involved in migrating the existing 2000 databases to SQL Server 2005 (Side by Side).
• Developing the successful Backup strategies based on Recovery models.
• Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases and transaction log on production/ development servers as per requirement.
• Involved in creating Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Raising the change management request and following up wif the customer approval, for making any changes in the production server
• Involved in DTS/SSIS Package, DTS Import/Export for transferring data.
• Involved in implementation of replications like Transactional.
• Implementing Database maintenance plan for Database consistence & Integrity
• On call 24/7 support to databases on weekly rotation.
• Experience wif SSIS,SSAS,SSRS
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Used SSRS to build health check reports & deploying the SSRS.
• Experience in using Data driven Subscription to prevent unforeseen circumstances.
• Monitoring SQL server performance using profiler to find the performance and dead locks.
• Worked On Call 24/7 Support on weekly basis.
• Monitoring and Troubleshooting SQL Cluster, Mirroring, Log Shipping.
• Creating the Jobs using maintenance Plans for Full, Differential and transactional log backups.
• Recovered many Databases at the time of Database crashes or data loss.
• Performing SQL Server database performance analysis and ongoing maintenance/tuning to ensure maximum performance.
• Maintaining and Monitoring Production, Pre-Production and Development database server environment.

Environment: MS SQL Server 2008R2/2005/2000, T-SQL, SSIS, Composite Software 5.0.0, Report Builder, Lite Speed, BCP, SQL Profiler, Log Shipping, Replication, Mirroring, Clustering, Windows XP/2000 and Windows 2003 Server.

Confidential, CA

Sr. SQL Server DBA

Responsibilities:

• Installed SQL server 2008 on windows 2003/2008R2 advanced servers, applied security fixes. Involved in Migrating SQL Server 2005 Servers to SQL server 2008
• Installed and Configured MS SQL Server 2008 R2, and responsible for configuration, tuning and provide support to all Production and development servers.
• Maintained database response times in 24X7 Production environments, proactively generated performance reports. Automating most of the DBA Tasks and monitoring stats.
• Planning and implementation of database backup/restore and disaster recovery.
• Analyzing business requirements and build logical data models that describe all the data and relationships between the data.
• Responsible for defining Check constraints, Business Rules, tuning data, indexes, and queries.
• Configuring and administering Database Mirroring, Log Shipping on SQL Server 2008R 2
• Developing SQL scripts for maintaining administration tasks.
• Additionally, designed and implemented a disaster recovery system.
• Configured CDC on Replicated Database.
• Running Index tuning wizard and rebuilding indexes for faster query response.
• Writing Stored Procedures, Functions and triggers based on the requirement.
• Creating jobs/maintenance plans for Database.
• Developed ER Diagrams using Visio 2000. Designed Star and Snowflake data model.
• Designing, Creating and Migration of DTS/SSIS packages to Development and QA Servers.
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Creating DTS Packages migration of data across different servers and Other Databases such as Oracle, Sybase and DB2 UDB.
• Implemented MS SQL Server security policies and granted object level permissions.
• Created jobs for rebuilding of indexes and updating statistics.
• Developed Cubes using SQL Server Analysis Services (SSAS).
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries wif MDX, Data Mining Models, developing reports using MDX and SQL.
• Planning, Configuration and Monitoring of Log shipping. Performed Role Reversal of Primary and Secondary servers of the log shipped database.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Configured Transactional replication between Primary Server and three Read - Only servers, wif separate Distributor server and experience in troubleshooting replication problems.
• Expertise in Security Issues such as creation and granting permissions on various Objects.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes.
• Performance Monitoring of MS SQL Server 2005/2008.

Environment: SQL Server 2005/2008 R2 Enterprise Edition wif Clustering, OLTP & OLAP environment that includes Production (24x7), Replication, Migration, SSAS, ETL, databases in SQL Server, Microsoft, Windows 2003/ 2008R2 Server, SSIS, SSRS, Erwin, Oracle 11g, Teradata, DB2 UDB

Confidential

SQL Server DBA/ Developer

Responsibilities:

• Responsible for Installation, Configuration and Complete Administration of MS SQL Server 2005/2003 on windows 2000/2003 Servers. Installation of SQL Server Service Packs & hot fixes.
• Successfully upgraded the databases from SQL Server 2000 to SQL Server 2005/2003.
• Monitoring and Troubleshooting jobs in Production, Preview and Development environment.
• Scheduling SSIS jobs (SQL Agent), Converting DTS packages to SSIS packages using DTS xChange tool.
• Involved in Health Check process for database and monthly auditing of the servers.
• Implemented the new SQL Server 2005 concepts like Policy Based Management, Central management servers, Table and Page level compression and Resource Governor.
• Virtualization of SQL Server in Production environment.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2005/2008, which includes in-place, side-by-side and stand alone migration.
• Implemented SQL Server high availability solutions including clustering, replication and log shipping
• Worked in Active/Passive and Active/Active cluster environment.
• Setting up daily and weekly backups directly to TSM (Tivoli Storage manager).
• Installed SQL Server 2005 on Active/Passive and Active/Active clusters as part of Upgrade.
• Worked on different DB replication techniques.
• Worked wif Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
• Designed database standards as per HIPAA and PHI specifics.
• Participated in Disaster Recovery.
• Participated in DR installation and trouble shooting(Mirroring, Logs hipping and High availability Cluster
• Experience in T-SQL and PL-SQL
• Optimized the Disk space for performance using RAID and SAN.
• Worked on Performance Comparison between SQL Server 2000 and SQL Server 2005 using RML Utility tool as part of Pre-Upgrade.
• Handling the RFC s and work orders assigned to me as part of daily responsibilities.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc as required.
• Documented the security standards and roles depending on Development, UAT and Production environments.
• Experience wif SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Tuning Queries and Database performance using tools Database Tuning Advisor, SQL Server Profiler.
• Managing security roles in SQL Suite.
• Performed the physical database analysis and feasibility requirements. dis involves the performance, security, archival, maintenance, and recovery requirements
• Worked on call 24/7 Support on weekly basis

Environment: SQL Server 2000/2005 wif Clustering, DTSxChange, MSAccess, VMware ESX, Windows 2000/2003, Litespeed 5.0, TSM, DTS, RML Utility, T-SQL, SSIS, SSAS and SSRS.

Confidential

Jr. SQL Server DBA

Responsibilities:

• Performed regular Database Maintenance task, Checking the disk Defrag procedures in Development environment
• Involved in Installation of SQL Server wif Multiple instances, Service packs and Hot Fixes
• Assisted in Setup and troubleshooting Active/Passive Clustering for SQL Server2005.
• Configured Disaster Recovery solution using Log Shipping. Setup for Snapshot and Transactional Replication between Servers, troubleshoot and monitor Publishers, Distributors, and Subscribers
• Used Index Tuning Advisor for Database performance for proper indexes.
• Involved in upgrading of existing Servers from SQL Server 2000 to SQL Server 2005
• Implementing Load balancing Replication across the Databases.
• Performed Database Refresh tasks from production to Development and Staging Servers
• Involved in Performance Tuning of the SQL Server for Web based Production and Development environments.
• Used PerfMon and Profiler Trace to monitor the Memory, CPU and Disk usage, the private bytes of each process, the trend in the Available Bytes, Performed Uploading of bulk data migration wif BCP Utilities.
• Performed Database consistency checks wif DBCC, Defrag, Index tuning and monitored SQL Server error logs
• Resolved the issue of mission critical of high usage of system CPU, Disk, Deadlocks issue and Transaction per/sec, Memory involved in performance monitoring of Memory, Processor, Disk I/O.

Environment: SQL Server 2000/2005 Windows NT/2003, VERITAS Net Backup and Crystal Reports.