Sql Server Database Administrator Resume
Dallas, TX
SUMMARY:
- 9+ years of strong professional experience in SQL Server 2014/2012/2008 R2/2005 as Database Administrator.
- Highly experienced in installing, configuring and administering SQL Server 2014/2012/2008 R2 on Standalone, Cluster and VM Ware Servers with Wintel OS (Windows Server 2014/2012/2008 ).
- Expertise in Migration and Upgrade of SQL Servers ranging from SQL 2000 and to higher family of SQL Servers.
- Extensive experience in designing and administration of SQL Servers in multi node clustering with Active/Active, Active/Passive Architecture.
- Experienced in Configuring, Implementing and Maintaining Database Mirroring.
- Ample experience in implementing Replication Models (Snapshot, Merge and Transactional) with different topologies.
- Highly experienced in Configuration, Implementation and Maintenance of Log Shipping.
- Expertise in Always - On Availability Groups (AAG) and HA/DR Troubleshooting
- Installed and configured MySQL on Linux and Windows environments.
- Managing/Troubleshooting MySQL 5.0.22 and 5.1.24 in production and developer environments on both Linux (5.0, 5.1) and Mac OS X.
- Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor Extensive experience with backup and restore methodologies using Native and third party tools (Lite Speed, NetBackup, and Red Gate).
- Experienced in Financial and Healthcare domains.
- Experience of Database Administration, design, development, maintenance and production support of relational databases, business applications, new server setup, MySql Server installation, upgrade, migration.
- Highly experienced with Business Intelligence in MS SQL Server 2014/2008R2 in SQL Server Reporting Services, SQL Server Analysis Services and SQL Server Integration Services.
- Expert in Database Design activities including Data Files and File group organization, Capacity Planning, Data partitioning.
- Experience in using tools like SQL Profiler, Windows Performance monitor and performance counters for Monitoring and Tuning MS SQL Server Performance, IDERA Diagnostic Manager.
- Experience in Performance Tuning, Disaster Recovery and troubleshooting critical production issues.
- Good knowledge and working exposure in Storage Concepts of RAID levels and SAN environment.
- Highly experienced in migration of data using BCP Utility, Bulk Insert commands, SSIS and DTS Packages, Import/Export Wizard and Copy Database Wizard.
- Extensive experience in design of logical and physical data modeling using Erwin data modeling tool.
- Experienced in Extraction, Transformation and Loading (ETL) process using DTS, SSIS.
- Created Linked Servers for OLEDB Data Source and Native Data Sources.
- Experience in developing management reports using SSRS.
- Tuned SQL Queries by examining execution plans, creating plan guides, adding SQL Hints where required, fine tune indexes.
- Very good knowledge of PCI/SOX regulations and documenting audit procedures.
- Developed Dash Board Reports on COGNOS 8.4 report studio
- Highly experienced in creating Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail and Database Mail.
- Experienced in programming tasks - Stored Procedures, Triggers, and Cursors for SQL Server 2005/2008/2012 and 2014.
- Good knowledge with features of SQL Server 2008 like Spatial, CDC, Encryption and File stream Data functionality.
- Expert in Tuning the SQL Server with tools like SQL Server Profiler, Database Engine Tuning Advisor, PerfMon and use DBCC commands and Dynamic Management Views for monitoring and tuning.
- Have experience in Power Shell Scripting.
- Good working knowledge in .Net Frameswork2.0/3.0/3.5,VB.Net,C#, ASP.Net, ADO.Net, XML and Web Services.
- Excellent problem solving, analytical, technical, interpersonal and communication skills with strong leadership abilities.
- Extremely diligent strong team player with an ability to take new roles.
- Experience working in a critical 24x7 critical production environments.
- Microsoft Certified IT Professional: Database Administrator.
TECHNICAL SKILLS:
Platforms: Windows 95/98/Me/XP/NT/2000 server/XP/2003 server/2008 server/2012,, Server/2014 PSI, VM Ware servers.
Databases: SQL SERVER 2000/2005/2008 /2008 R2/2012/2014,MySQL, MS-Access
Programming Languages: SQL, PL/SQL, VB 6.0, VB.Net, C, C#, VBScript
Web Technologies: Asp.Net, HTML, DHTML, XML, IIS 6.0, Java Script
Tools: SQL Server Management Studio / Enterprise Manager, IDERA, SQL Diagnostic manager, IDERA SQL safe, SSRS, SSAS, SSIS, Enterprise Manager, SSMS, Visual Studio 2005/2008/2012/2014, VERITAS, Quest LiteSpeed, Red Gate, Erwin, Tivoli, SCOM, ESM, RSAM, Guardium.
PROFESSIONAL EXPERIENCE:
Confidential,Dallas,TX
SQL Server Database Administrator
Responsibilities:
- Successfully designed and implemented the disaster recovery with High availability solutions like Failover Clustering, Mirroring, Log Shipping and Replication.
- Used different tools from IDERA suite like SQL Diagnostic manager for monitoring 24/7 Performance measures, SQL Defrag Manager to effectively manage the hot fixes, SQL Virtual Database to access data in SQL backup files without restoring.
- Ability to carry out security tasks at network level such as block/unblock TCP/IP ports through firewall on both Linux and windows and block/unblock remote access to MySQL server.
- Configuring/Installing/Troubleshooting Apache and PHP.
- Created data extracts as part of data analysis and exchanged with internal staff.
- Performed MySQL Replication setup and administration on Master-Slave and Master-Master.
- Documented all servers and databases.
- Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor.
- Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients.
- Installed SQL Server 2012,2008R2 and 2008 on Production, Development and UAT boxes
- Migrated SQL Server 2005 to SQL Server 2008, SQL Server 2012 and SQL Server 2014.
- Designed Oracle to SQL Replication to Accelerate the Data Ingest Process from various RDMS server to Oracle
- Successfully Implemented the Data Optimization techniques by reviewing the database designs and identifying the areas of improvisation there in implementing partitioning and using Resource Governor to better Share the resources between the Multiple application connecting to SQL server
- Actively taken part in Data Modeling for various initial client setups and designing a set prototype for the Database Structure
- Automated various jobs and effectively taken part in maintaining the security on the server.
- Automated the Monthly and weekly claims and eligibility data processing for various client using SSIS advanced functionalities.
- Create and design backup and restore strategies on new servers based on application needs.
- Create the Generic procedures for the various business requirements to process the Provider Loading.
- Created the user defined function for various business needs
- Create the Different Reports using SSRS advance technologies
- Created indexed generic views to facilitate easy user interface implementation, security, and triggers on them to facilitate consistent data entry into the database.
- Involved in creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
- Resolved Deadlock & Blocking Lock Issues by setting Trace Flags like T1204 and T1205
- Created Linked Servers between SQL Servers and other Heterogeneous environment
- Has done Extensive Performance Tuning by using advance techniques provided by latest SQL server editions.
- Set Different Performance Counters to setup Perform Traces to monitor the performance of the production servers and setups alerts based on the performance.
- Debugging troubleshooting with database performance and tuning issues.
- Tuning SQL Queries
- Coordinating with team members
- On Call 24*7 Production Support
Environment: Windows 2008 Advance Server, Windows 2003 Advance Servers, Windows 2000 Server, SQL Server 2008,SQL Server 2012. Server 2014, Idera SQL Diagnostic Manager, SAP,Oracle 11g
Confidential,River, NY
SQL Server Database Administrator
Responsibilities:
- Perform level II incident on call 24X7 support and troubleshot day-to-day problems encountered on production databases and custom application issues.
- Implement and troubleshoot in Performance tuning using Dynamic Management Views (DMVs) and System Catalog Views, Profiler and Server-side Traces, Windows Performances Monitor and built in performance reported in SSMS, Query Plans, and Database Tuning Advisor.
- Expert in using SQL Defrag Manager to effectively manage the hot fixes, SQL Virtual Database to access data in SQL backup files without restoring.
- Responsible for applying service pack and hot fix to all version of SQL Server.
- Implement and maintain databases, perform software installations and upgrades, monitor database performance, perform capacity planning and SQL Server clustering, and manage database Quality Assurance including database consistency check.
- Responsible for installing SQL Server on Standalone and Clustered servers.
- Designing, implementing, maintaining, and generating daily report to monitor backup job for all SQL Servers.
- Perform post-upgrade tasks including updating statistics, changing data-base compatibility level, reconfiguring log shipping, executing upgrade testing, verifying agent jobs and maintenance tasks, bringing system online and monitoring system activity.
- Manage MSSQL Server (storage, memory, processing) and their dependencies and performance bottlenecks.
- Responsible for maintaining database security to tightly secure the data and manager security with different roles for better security management.
- Responsible for database security of the test and development application system databases.
- Review and deploy the Stored Procedures, Triggers, and other TSQL code developed by developers.
- Ease administrative work through automatic script performing daily/weekly backups.
- Monitored and ensured Disaster Recovery for critical database.
- Ensured developers coordinated their efforts in managing and maintaining different application databases.
- Implement various automated scripts to monitor disk space, fragmentation, failed jobs steps, backup and mirroring activities, and configured various job alerts for immediate notifications.
Environment: SQL Server 2000/2005/2008 /2008 R2/2012
Confidential,New York,NY
SQL Server Database Administrator
Responsibilities:
- Implemented Functions, views, triggers and stored procedures and enforced business rules using constraints.
- Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
- Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
- Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
- Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
- Prepared Documentation for the Disaster Recovery plan, Worked in Active passive cluster environment
- Extensively worked on trouble shooting and fine-tuning of databases for its performance, Rebuilding indexes with different fill factors and update statistics manually as required.
- Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
- Improved the server performance by collecting information based on WAIT Statistics and do required server level changes.
- Worked on critical consolidated environment with upgrades and hotfixes with minimal downtime.
- Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2005.
- Managed data warehouse SQL Servers and assisted ETL developers with the load activity and trouble shoot issues related to loads.
- Monitored and modified Performance using execution plans and Index tuning
- Recovered the System and User databases from suspect mode, Expert in sizing Temp database.
- Expertise in DBA tasks like handling user’s permissions and space issues on Production and handling maintenance jobs including backups and restores.
- Hands on experience in trouble shooting database issues, Update statistics, database integrity check and Backup operations
- Troubleshoot problem requests with Microsoft Engineers on highly critical environments for immediate resolutions.
Environment: SQL Server 2000/2005/2008 R2 with clustering, Replication, T-SQL, Windows 2003/2008R2 64-bit, SSIS, IDERA SQL safe, Profiler.
Confidential,Brooklyn,NY
SQL Server Database Administrator
Responsibilities:- Provided 24X7 supports for Database administration, deployments/upgrades, DR, patching.
- Performed performance tuning using Dynamic Management Views (DMVs) and System Catalog Views, Profiler and Server-side Traces, Windows Performance Monitor, DBCC commands and in-built SQL tools like SQL Profiler, DTA (Database Engine Tuning Advisor).
- Implemented custom Maintenance jobs - schedule to run daily and on weekends (tasks like rebuilding. Indexes, defragmenting Databases, Shrink Database, and Database complete backup).
- Migrated SQL Server 2000 to SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.
- Created/developed Stored Procedures Triggers to handle complex business rules, history data and audit analysis.
- Involved in working with IDERA SQLDM & Multi Query tool for SQL Databases monitoring and administration.
- Responsible for installing SQL Server on the new build Standalone and Clustered servers.
- Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning and SQL Server clustering, and managed database Quality Assurance including database consistency check.
- Disaster Recovery for critical database with compliance for HIPPA
- Monitored strategies, processes, and procedures to ensure data integrity; optimized/reduced data redundancy; maintained required level of security for all production and tested databases.
- Ensured developers coordinated their efforts in managing and maintaining different application databases.
- Performed post-upgrade tasks including updating statistics, changing data-base compatibility level, reconfiguring log shipping, executing upgrade testing, verifying agent jobs and maintenance tasks, bringing system online and monitoring system activity.
- Migrated DTS packages in SQL Server 2000 to SSIS of SQL Server 2005.
- Responsible for applying newest service pack and hot fix to all the SQL Server.
Environment: SQL Server 6.5/7.0/ 2000/2005/2008 /2008 R2, SQL DM (IDERA).