SUMMARY

• I am a Microsoft and Epic certified professional with experience in database administration, analysisimplementation, and performance monitoring and tuning using SQL Servers 2014/2012/2008 R2/2008/2005and Epic Cache database servers in Production, Development and Staging Environments.
• Currently working in a demanding production support environment managinglarge volumes of business/clinical critical data in a healthcare environment. A committed team player, self - motivatedwith the ability to communicate at all levels.
• Experience in handling production systems in 24/7 environment (rotating on-call)
• Experience in Administering and managing Databases
• Experience in managing multiple instances of database servers on-site and remotely
• Installed and configured MS SQL Server 2012, 2008 R2/2005 in all environments (standalone & clustered)
• Administered and supported 150+ number of instances.
• Expert in migration/upgrade of SQL from and 2012
• Experience upgrading and migrating SQL Systems from lower version to higher version
• Experience in Implementing and handing SQL Server systems in Clustered environments
• Experience in Implementing SQL Server 2008 environment in a Virtual Environment
• Expert in implementing High Availability options Failover Clustering, Log shipping, Mirroring and Replication (Transactional, Snapshot & Merge) and migration
• Implemented Database Mirroring in MS SQL Server 2005 and SQL Server 2008
• Experience in capacity planning and implementing disaster recovery
• Expert in FULL, DIFF and LOG Backup for all production systems
• Experience in using third party tools like Snap Manager, HP Data Protector, ITSM
• Resolving backup failure issues.
• Worked extensively on MS SQL Server 2005/2008/2012 Integration Services (SSIS)
• Experienced in Deploying SSAS packages
• Extensively worked on SSIS for data manipulation and data extraction
• Created SSIS packages to Extract and Load data from diverse source (flat file, excel and xml)
• Used Send Mail, Bulk Insert, Execute SQL, Import Export control extensively in SSIS
• Scheduling package execution in SSIS
• Installing packages on multiple servers in SSIS
• Extensive use of DMV’s in MS SQL Server 2012/2008/2005
• Experience in performance tuning MS SQL Server 2012/2008/2005 for best performance
• Expert in using SQL Server 2012/20 profiler trace for long running queries
• Excellent knowledge in fine tuning queries and jobs taking a long time
• Excellent knowledge in understanding query execution plans and operators
• Expert in Creating, Suggesting and implementing Indexes (Clustered, Non Clustered, Unique)
• Experience in using tuning wizard in MS SQL Server 2012/2008/2005

PROFESSIONAL EXPERIENCE

Confidential, Saint Paul, MN

Database Admin /Epic ODBA

Responsibilities:

• Assists in the data strategy and helping to construct, deliver and maintain the data architecture. Designs, builds and maintain the databases. Establish the maintenance of appropriate data backups and the ability to recovery to any point within that backup. Provide database technical services and support to both internal and external clients.
• Work with report writers to identify and resolve any discrepancies between Cache and Clarity.
• Setup and maintain user and administrator access to database environments.
• Maintain database security according to best practices for Epic Cache Database.
• Responsible for monitoring and maintaining monitor and maintains Enterprise Cache database platforms for critical business and clinical applications
• Maintain knowledge of, and complies with, all relevant laws, regulations and policies, procedures and standards. Actively participate in creating and implementing improvements to achieve clinical, satisfaction and/or efficiency outcomes. . Assist in managing the life cycle of multiple database tools by enabling smooth upgrades and/or installation and support of new capabilities; assist in the establishment and maintenance of the data architecture.
• Assist in the development of the capacity planning function to properly identify needed hardware, software, database configuration / architecture to support application / business needs. Design, builds, verifies, implements and maintains the structure of databases to support the business needs including integration of vendor database solutions into data environment.
• Prepare reusable project and system related documentation consistent with standards and procedures outlined in the data architecture approach to ensure data quality, availability and reliability. Create processes to ensure reuse, recovery and maintenance.
• Provide database level 3 support to assist Level 2 in their production support capacity
• Provide project teams with performance tuning, query optimization, tables and view advice, and use of DBMS tools and hardware capabilities (e.g. index tuning, caching, buffer management).
• Review new applications for their ability to be integrated into environment specifically around data, including design around security, maintainability, reliability, performance and metrics.
• Review new database programs, functions, procedures, and packages before they are loaded to production database.
• Upgrading/Patching databases and systems as requested.
• Perform database mirroring, replication and Always on
• Support data loading, conversion and batch job operation and do trouble-shooting of development/production system.
• Recommend, schedule, and perform software improvements and upgrades.
• Plan and design database physical structure to accommodate large transaction volume and high availability.
• Perform database and application monitoring and tuning to ensure databases run at peak performance. Troubleshooting of performance issues.
• Assist in the design and implementation of database security policy.
• Work with developers to implement SSIS packages, Stored Procedures and Triggers.
• Provide solutions for database sizing and capacity planning, server requirements and space requirements.
• Work with System Engineers group to design, implement and test enterprise backup and recovery solution, including Disaster Recovery initiatives.

Confidential - St. Paul, MN

SQL SERVER PRODUCTION DBA

Responsibilities:

• Practical and solid experience with SQL 2000, SQL 2005, 2008 and 2008 R2 in multi-nodes Windows clustering environments
• Knowledge of migrating databases residing on servers in one data center to another and upgrading database platforms to newer versions
• Experience in the Database Design, analysis, development, administration and support of SQL Server in Production, QA, Test and Development environments
• Experience in install, patch, configure, monitor, maintain, and performance tuning on production databases
• Experience with supporting large database over 1 TB
• Extensive experience in T-SQL, Replication, Clustering, Database Mirroring, Log Shipping, Backup and Recovery, High Availability, DTS, SQL Jobs, linked servers, SQL Profiler, PerfMon, Policy Based Management and SOX audit
• Knowledge of migrating databases residing on servers in one data center to another and upgrading database platforms to newer versions
• Experience in the Database Design, analysis, development, administration and support of SQL Server in Production, QA, Test and Development environments
• Administration and support on 150+ SQL Server instances in multiple data centers including Production and Test Environment
• Perform SQL Server installations, upgrade and patches in multi-nodes Windows cluster environments.
• Perform database performance analysis, tuning and disaster recovery
• Provide technical recommendation and database support on assigned projects with different vendors, application support and Windows admin group
• Provide DBA support on existing SQL Server environments including change management, code releases, break fixes and (7X24) on call support
• Work with Enterprise Monitoring team to configure and review database monitoring.

Confidential - Houston, TX

SQL SERVER PRODUCTION DBA

Responsibilities:

• Install clustered and stand-alone SQL server 2012, 2008 and 2008 R2
• Create and maintain databases after logical and physical database design
• Administration of more than 150 instances in different version of sql server
• Analyze the possible difficulties before migration, find the solutions and testing in development server
• Migrating User, logins and all the privileges and roles
• Migration from SQL Server and 2008 to SQL Server 2012 version
• Managing database backup and recovery. Create database objects including tables, triggers, views, stored procedures, indexes, defaults and rule
• Experienced in trouble shooting, performance tuning, query tuning, index tuning using DBCC command, Wizards and SQL Profiler
• Set database access privileges for different users and user groups
• Review and update stored procedures for optimal performance
• Maintenance of clustered and non-clustered indexes. Create jobs and monitor job history for maximum availability of data and to ensure consistency of the databases
• Deployed SSIS Packages to transform data from excel file to SQL Server database
• Perform database consistency checks at regular intervals
• Monitor SQL Server activity through profiler and performance monitoring software like PERFMON
• Developed standards for SQL Server maintenance / updates
• Design and implementation of database maintenance plan
• Performance optimization and normalization of database
• Job, Scheduling, batch, alert and E-mail notification setting
• Maintained Disaster recovery strategies for the database and fail-over methods
• Monitor SQL Server log files.

Confidential

Jr.SQL Server DBA/Developer

Responsibilities:

• Performed Installations and configuration of SQL server 2005 and upgraded SQL server installations wherever necessary.
• Applied Service Packs for Microsoft SQL Servers and Windows 2003 Servers.
• Involved in Capacity Planning in terms of Disk, CPU and Memory.
• Created Users and Roles, and managed security and permission of database.
• Recovering backups of SQL Server production databases in test servers as part of regular maintenance activities.
• Monitoring Log shipping/Replication and troubleshooting of errors.
• Security issues related to logins, database users, and Application Roles and Linked Servers.
• Performance Tuning of SQL queries and stored procedures using SQL Profiler
• Backups and Restoration of data/database using a Third Party Tool SQL Lite Speed.
• Responsible for Database Recovery, database Backups and Restores, attach and detach databases, move it on different servers.
• Fixed all the existing issues with the SQL Server and SQL Agent.
• Management of day-to-day database operations including issue resolution, resource utilization and task schedule management.
• Documentation for best practices, policies, procedures and standards.