OBJECTIVE Looking for SQL Database Administrator position

Summary:

• Over 7 years of IT experience in Database Administration and System Administration in various domains like Finance, Insurance, Healthcare, Mortgage etc.
• Expert in installation and configuration of MS SQLServer2014/2012/2008/2005/2000.
• Experience of Upgrading and migration from earlier version of SQL Server to SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 in different environments.
• Proficient in performance tuning of T-SQL queries, stored procedures and debugging the poorly written code and helping application teams in development life cycle.
• Extensive experience with SQL Server Database objects with the ability to leverage T-SQL to manipulate them
• Expert Level skills in providing 24x7 support in Production, Preview and Development environment.
• Handled up to 10 TB of data.
• Expert in monitoring SQL Server Performance using SQL Profiler, Index Tuning Wizard, Performance dashboard, Windows Performance Monitor.
• Expert in designing disaster recovery model for corporate databases.
• Expert in utilizing different Monitoring tools including third party tools.
• Implementing and administering database replication between SQL Server databases as well as dissimilar databases.
• Experience in MS SQL Server client/server connectivity, query optimization, replication, mirroring, back-up/recovery, running Database Consistency Checks using DBCC commands.
• Worked extensively in clustered environment active / passive to further increase scalability and stability of business critical systems.
• Solid experience and outstanding knowledge of high availability SQL Server solutions, including Log shipping, Replication and SQL Server clustering.
• Monitored the size of the transaction log. Managed databases on multiple disks using disk mirroring and RAID technology.
• Strong Leadership and Managerial skills, energetic, self-starter, quick learner and a team player.

Technical Skills

PROFESSIONALEXPERIENCE

Data Group ITConsulting

Confidential

• Support for 24 x 7 and problem solving using available resources making recommendation
• Designed, development and administration of MS SQL Server 2014/2012/2008/2005 databases
• Handled Performance monitoring, reporting, and tuning of MS SQL Server 2014/2012/2008/2005 databases
• Managed maintenance of back-ups recovery procedures
• Installed and maintained MS SQL Server 2014/2012/2008/2005 databases
• Managed security and access control for MS SQL Server databases
• Ensured all database servers are backed up in a way that meets the business's Recovery Point Objectives RPO
• Tested backups to ensure the company meet the business' Recovery Time Objectives RTO
• Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
• Configured SQL server monitoring utilities to minimize false alarms
• As new systems are brought in-house, chose whether to use clustering, log shipping, mirroring, windows, or other technologies
• Prepared daily report on the job failures, backup failures and disk space.
• Creating Indexes on right columns of a table that help providing T-SQL queries to run faster.
• Extensively used Database Performance Monitoring tools for performance tuning.
• Designed and implemented database maintenance plan.
• Used Index tuning wizard and rebuilding indexes for faster Query Performance.
• Involved in resolving dead lock issues and performance issues.
• Adopt the changed technological tool to automate the programs improve the system performance and reduce the manpower from time to time.
• Smoothly handling the project under critical time, when unwanted events happened
• Involve in study, design, development and enterprise database architecture of the existing and new system
• Involve in infrastructure design for its scalability of the system using MS Clustering, load balancing.
• Reporting to the Management about the project status and its schedules from time-to-time.
• Meeting/Conferences among technical groups.
• Immediate solution to customer service for existing problems

Environment

Total: SQL Databases 200 , Replicating Databases 60 , SQL Database Sizes Range 250GB - 3000GB/ 4TB , COMPAQ/DELL - Servers - 100

Confidential

Data Analyst

• Analyzing hospital discharge data in the database system
• Creates, analyzes, and maintains a data dictionary and meta data.
• Supports efforts to ensure that data standards are developed and maintained.
• Ensures that the uses of data through reports and queries are accurate.
• Supports business and system re-engineering and architecture development to define future data needs.
• Serves as an organizational consultant on matters relating to databases by providing expertise to assist users in meeting their needs.
• Reviewing applications for CON Certificate of Needs and log them in using the database management system
• Research and the identification of key data sources
• Converting the file system to computerized data base system
• Perform analyses, review research conducted and information received from various locations
• Write reports in a clear and concise manner that summarize the information gathered and identified during research
• Expert on Microsoft Excel and Access

Environment:

SQL Server 2000/2005, MS Access, MOSS 2007, DB Artisan, Windows NT/2000 Advanced Server, MOSS 2007, T-SQL, SSIS, SSAS and SSRS.

Confidential

SQL Server DBA

• Administered database backup recovery process
• Highly proficient in database Backup, Restore, Recovery, Linked servers, and Database Maintenance Plans.
• Experience on High Availability and Disaster Recovery like Replication, Log shipping, Mirroring and Clustering and database security and permissions
• Created Security by setting up groups and then logins for each Roles or Users for Maintenance of Databases.
• Documented Disaster recovery plans and participated in disaster recovery drills.
• Successfully tested and implemented Log Shipping technique used for warm backup solution for MSSQL server2005/2008 databases.
• Configured, setup the log shipping/ Database Mirroring/Replication/ Clustering/ Disaster recovery.
• Database Maintenance and Troubleshooting
• Backup Recovery of databases
• Worked with development team in tuning complex stored procedures and T-SQL scripts that were effecting OLTP application
• Performance Tuning of SQL Servers/ Replication Servers, Databases, systems, Networking configuration optimal and query optimization using Enterprise Management and SQL Expert.
• Error log monitoring for MSSQL Servers/ Replication Servers.
• Database and Replication monitoring for optimal response and higher throughput
• Setup for disaster recovery, fail over strategy, High Availability of system using MS-Clustering for Windows NT/2000.
• Used Powershell scripting to automate the SQL Server administration.
• Maintaining the Database Source Code Control and versioning using Microsoft Visual Source Safe and third party program.
• Involved and implemented Software Development Life Cycle for the existing and new systems.
• Involved the report generation for the users and management using SQL Reporting Service and BI for data marts

Environment Total: SQL Databases 60 , Replicating Databases 30 , SQL Databases Sizes Ranges - 210GB to 1500GB/1.5TB , NT/2000 Compaq/Dell 125, Servers - 25

Confidential

Sr.SQL Server DBA

Active Health Management basically provides health services in many aspects. Active Health Management is a leading provider of health management services, including disease management, clinical decision support and personal health records.

Responsibilities:

• Providing 24x7 supports to Production, Preview and Development servers.
• Involved in installations, upgrades, patches and fixes.
• Successfully upgraded the databases from SQL Server 2000 to SQL Server 2005.
• Monitoring and Troubleshooting jobs in Production, Preview and Development environment.
• Work with project teams for Migrating data from MS Access to SQL Server 2000/2005.
• Involved in Health Check process for database.
• Writing DTS SQL 2K as well as SSIS SQL 2K5 packages for daily sales and delivery reports as well as for adhoc data transforms and data extraction for the Data Migration team and also upgraded DTS packages to SSIS packages.
• Assisted in the design and development of the data warehouse
• Implemented SQL Server high availability solutions including clustering, replication and log shipping
• Implemented the new SQL Server 2005 concepts like Data partitioning ,Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV's, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
• Setting up, Configuring and troubleshooting Log Shipping for databases on Disaster Recovery DR servers.
• Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
• Coordinated physical changes and performance monitoring of two replicated production servers and two development servers.
• Studying requirements of the client based on information and documents.
• Develop SSIS Packages to transform data from excel/Access file to SQL Server database.
• Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler.
• Supported more than 100 .NET applications.
• Design and implement Backups and Restore database policies.
• Managing security roles in SQL Suite.
• Worked on partitioning VLDB s
• Performed the physical database analysis and feasibility requirements. This involves the performance, security, archival, maintenance, and recovery requirements
• Monitor performance and current space utilization reports to management along with recommendations for any corrective action.

Environment: SQL Server 2000/2005, MS Access, MOSS 2007, DB Artisan, Windows NT/2000 Advanced Server, MOSS 2007, T-SQL, SSIS, SSAS and SSRS.

Confidential

Financial Aid office Assistant

• Organized and maintained student files database
• Answered and directed phone calls appropriately
• Answered students' Question about their financial aid status
• Type correspondence, reports and other documents
• Maintained confidential records and files using computerized database management system
• Prepared documents and reports using various computer applications

Confidential

System Administrator

• Maintained back up files and ensured proper recovery steps are in place
• Managed security and access control for Server databases
• Run and take backups for every day's transactions
• Maintained and monitored the bank's database system
• Served as a librarian to keep all the backup files and system recovery documentations
• Trouble shooting with regard to system, monitored the networking flow
• Run various types of reports to the users
• Administered Database Management System