SQL Server Administrator, Clustering, Always On, On-Call, deployment
Resume:
PROFILE SUMMARY
Have over * years of experience in Database Administration and a total of 5+ years’ experience in Information Technology industry.
Experienced in working with various SQL Server versions from 2017, 2016, 2014, 2012, 2008
Experienced with Installation, Configuration, Database Migrations and Upgrading of SQL Server 2005 to SQL Server 2008 and to SQL 2012 and SQL 2016, 2017 as well.
Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.
Experience in Microsoft SQL Server Database Administration including planning, implementing, backup, and recovery strategies.
Experience in planning and implementing Microsoft SQL Server Security and database permissions.
Develop and maintain standards of all data warehouse and ETL.
Ensure compliance to all specifications and documents all data warehouse administration activities.
Monitor ETL server and databases and ensure optimal performance.
Coordinate with Quality Assurance and Offshore ETL teams.
Analysis and documentation of existing database structures and data load processes.
Monitor all databases and resolve all performance issues in same.
Perform tests and maintain MS SQL Server databases in an MIS environment.
Administer databases and resolve all issues to ensure data accuracy.
Coordinate with business analysts and prepare design for systems.
Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.
Designed and implemented stored procedures views and other application database code objects.
Maintained SQL scripts indexes and complex queries for analysis and extraction.
Performed quality testing and assurance for SQL servers.
Experience in allocating system storage and Capacity planning for future
Storage requirements for the database system.
Implement operational automation using scripts.
Experience in different team projects with good project implementation experience, team skills, troubleshooting, presentation abilities and issue resolution capabilities.
Excellent communication, analytical and interpersonal skills and ability to learn new concepts.
Troubleshoot and resolve database problems with defined SLA window
Skilled at assessing client needs, working in a group, suggesting ideas that enhance efficiency and maximize performance, implementing cutting-edge technology solutions, and training/supporting end users.
Experience as a SQL Server DBA working with SQL Server 2012/2008 R2/2005 in an enterprise environment.
Performance tuning and optimization of databases structures
Worked with managing SQL Server in a multi-node Cluster Environment.
Working on Pre-deployment procedures and compatibility from SQL Server 2008
Through SQL 2012 software.
Provide 24x7 on call Application DBA support.
Flexible and versatile to adapt to any new environment and work on any project.
TECHNICAL SKILLS
Operating Systems: Windows Server 2005/2008 and 2012.
RDBMS: MS-SQL Server 2016, 2014, 2012 and 2008
Database Technologies/Tools: SQL Server Manager, T-SQL, SSIS, Query Analyzer, SQL Profiler, Database Tuning Advisor (DTA), ETL, Replication, Jobs and task creating and scheduling, DBCC and BCP,
Tools: Crystal Reports, RedGate SQL Backup, Data Protection Manager, TimeData, Symantec Backup Exec, Knowledge Nase Model (KBM) Upgrade Utility, SQL Diagnostic Manager, Total Network Inventory, Foglight, Spotlight, SQL Diagnostic Manager (SQLDM), Veritas NetBackup, Litespeed, GoldenGate, ServiceNow, SQL SentryOne, Github, Active Role Console.
EDUCATION & CERTIFICATION
SQL Database Administration and Implementation, Maintenance and Database Development training from New Horizons, Charlotte. NC.
Associates in Network Security Professional from ITT Technical Institute. Charlotte. NC Graduated March 2011
Radiation Protection Technology (RPT) from Spartanburg Community College. Spartanburg, SC
PROFESSIONAL EXPERIENCE
Client: InComm, Atlanta GA
Duration : June 2018 – May 2020
Position : SQL Database Administrator II / MySQL DBA
With more than 25 years of global experience in the FinTech industry, InComm has partnered with the largest and most popular retailers and brands in the world. Our products and services – which range from prepaid cards to switch payment processing – enable retailers and brands to create a seamless commerce experience – whether that's in store, online or via mobile. Headquartered in Atlanta, Ga., our network stretches across the globe and touches a wide variety of consumers.
Responsibilities:-
Responsible for administering one or more databases in a production environment. Install, upgrade servers and application tools.
Allocates system storage and plans for future allocations. Creates primary objects (tables, indexes, views etc) during application design, create and allocate storage for the database. Enrolls the database users and ensure the system is secure.
Interact with business partners (External Customers) on system and performance improvement techniques.
Designed and Implemented Replication, Mirroring, Log Shipping and Always On (high availability) features to enhance the availability of the database.
Worked on configuring GoldenGate replication from Database server to Reporting server
SQL Server & OS level Monthly Patching and compliance activity
Change Management & Break/Fix work, Production deployment/Releases.
Worked on MySQL service access as well as Production deployments
Worked on SQL Server Installation, Configuration, monitoring, and support.
Worked on SQL Cluster environments
Migration of SQL server from 2012 to 2014/2016/2017.
On-Call rotation for after hour and weekend Production Support.
Monitoring SQL SentryOne (tool) for all SQL Servers to monitor and capture performance metrics.
Configure High Availability Always-ON on SQL 2012, 2014, 2016 and DAG (Distributed Availability Group) on 2017 database servers.
Review T-SQL code to verify it meet standards for both performance and error handling according to DBA standards.
Environment:
SQL Server 2012 2014 and SQL 2016, 2017 T-SQL, Enterprise Manager, Query Analyzer, SQL
Profiler, Performance Dashboard, Windows 2012 and Red Gate (Data Compare), Speed lite, Attunity, SQL SentryOne, ServiceNow, Active Role Console, GitHub, GoldenGate.
Client: Bank of America, Charlotte NC
Duration : June 2017 – November 2017
Position : Database Administrator
Bank of America offers a wide range of services for all our customers, from individuals and small businesses, to corporations and government entities. The bank provides deposit, lending, cash management and investment services to more than 6 million consumer and small business customers across 19 states and the District of Columbia. Customers can bank whenever and wherever they want via more than 2,600 branches, online and mobile services along with 9,000 ATM machines, many of which can be used to make deposits and cash checks.
Responsibilities:-
Set up and install new SQL Servers 2005, 2008, 2012 and SQL 2014 and configure the required users and permissions after new setup.
Also very much involved with migration of different SQL version from 2005, 2008 to SQL 2012, 2014 and SQL 2016.
Provide periodic Backup and Restore process including Log shipping, database capacity issues, Replication, Clustering, and Mirroring.
Configured SQL Servers with appropriate settings to resolve various resource allocation
& memory issues
Check DBCC output to ensure database integrity and consistency, check hard disk space to ensure they have enough space, check database and transaction logs, event logs and error logs.
Involved in securing SQL Servers by creating users, roles and assigning permission to roles.
Extensive experience on working and troubleshooting with Log Shipping and Mirroring.
Experienced in restoring databases to recover critical data in production environments.
Experienced with Always On in production environments.
Experience in Performing SQL Native Backups, Backups using LiteSpeed.
Worked closely on a Backup Certification Project to investigate backup issues and recommended several methods to backup databases as well as servers.
Worked on windows cluster environment (Active/Passive, Active/Active)
Configuring, tuning, and optimizing SQL Servers.
Performance testing on stored procedures, indexes, and triggers.
Participated in efforts to provide 24/7 global DBA support to software developers located in United States and Asia.
Environment:
SQL Server 2008, 2012 2014 and SQL 2016, T-SQL, Enterprise Manager, Query Analyzer, SQL
Profiler, Performance Dashboard, Windows 2000, Windows 2003, Red Gate.
Client: Windstream Communications, Greenville. SC
Duration: August 2015 – September 2016
Position: Database Analyst
Windstream, is a provider of voice and data network communications (broadband, VoIP, MPLS), and managed services (virtual servers, managed firewall, data storage, cloud-based voice, etc.), to businesses in the United States. The company was formed in 2006, when Alltel's local telephone service merged with Valor Communications Group out of part of GTE (now part of Verizon's) local telephone business in the Southwestern United States. Windstream is a partner with Dish Network, offering satellite service to its customers.
Responsibilities:
Installed SQL Server 2012 and 2014 on windows 2012 servers, applied service packs and security fixes for all servers.
Maintained a stable process of database refresh from production to internal environments
Experienced in installing, configuring and maintaining 2 Node Failover MS SQL clusters for production environments.
Involved in setting up Transactional and Merge Replication and maintained them in production servers.
Experience in creating backup and restore strategy and setting up the backup maintenance plans for production, test and development servers.
Involved in recovering SQL Server in disaster recovery solutions and created the document for disaster recovery procedures.
Managed VERITAS net backups and LiteSpeed backups.
Experienced in restore production databases and data refresh between the environments.
Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
Involved in database capacity planning and give them advice to procure system hardware.
Experienced with securing SQL Server, user administration and assign the permission.
Experienced with setting up the link server and run the reports from different servers.
Experienced with data refresh between production and test environments.
Managing security tasks like granting and revoking permissions.
Proactive and Reactive tuning of databases in every stage of the project.
Experienced with setting up SQL Security features and maintained the user administration.
Assist the SQL developers to optimize the SQL queries and stored procedures.
Created check lists to install SQL Server, SQL Cluster, service packs installation on standalone and cluster servers and hot fix
Worked in a team environment and involved in 24/7 production environment.
Environment:
SQL Server 2008/2012/2014, SQL Profiler, RedGate, SharePoint, NetBackup, FogLight, Litespeed.
Client: IHS. Fort Mill, SC.
Duration: March 2011 – December 2014
Position: SQL DBA
Integrated Healthcare Solution provides a comprehensive healthcare informatics, technology and consulting solution to help the clients achieve their healthcare delivery goals by improving access to clinical data and streamlining clinical workflows, reducing costs, increasing revenues and achieving substantially improved operational effectiveness.
Responsibilities: -
As an intern I got extensive hands on training on SQL 2005 and SQL 2008 administration.
Installed and configured SQL Server 2005 and SQL 2008 on Windows 2003/2008 servers.
Involved in upgrading SQL Server 2005 to SQL Server 2008 servers with senior DBAs. Worked with the application development groups to test the successful SQL Server upgrade.
Also installed and configured SQL Server 2008 on Windows 2008 servers.
Installed and configured SSIS, SSRS components on ETL servers for development and production environments.
Configured and maintained Transactional and Merge Replication for several different production environments.
Configured and maintained Database mirroring with witness for automatic failover and also without witness for manual failover.
Created the database maintenance plan for optimization and integrity checks to improve the database performance.
Involved in securing SQL Servers by creating users, roles and assigning permission to roles.
Experience in improving SQL Server performance using Performance Monitor, Performance dashboard, SQL Server Profiler, Database Tuning Advisor and execution plans.
Maintained Backup and storage related issues in MS SQL Server platforms.
Experienced in creating the disaster recovery plan for SQL Server mission critical production databases and involved in doing the same.
Experienced in restoring databases to recover critical data in production environments.
Proficient with upgrading SQL Server databases to the latest Knowledge Base Models, NextGen versions, Med-updates, Formulary Updates and BTU updates.
Experienced working with Med-updates and Formulary Updates.
Enhanced end users understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials.
Answered technical questions regarding software products and their requirements within related industries.
I was responsible for 24/7 critical production support of 35+ SQL Servers, out of which 25 servers are production servers, others are test and development servers.
Created documentation on policy and procedures.
Environment:
Enterprise Practice management (EPM), SQL Server 2005\2008, SQL Diagnostic Manager (Idera), SQL Profiler, Database Tuning Advisor (DTA), NDC Remap Utility.
Contact this candidate