SUMMARY:

• Experience in Database Administration on SQL Server (2000, 2005, 2008, 2008R2, 2012, 2014 and 2016) Databases.
• Experience implementing backup and restore, ensuring proper recovery and recovery models.
• Experience with database automation tasks using scripts.
• Experience logical and physical database modeling.
• Experience in Performance Tuning and Optimization (PTO), using SQL Server native monitoring and troubleshooting tools.
• Huge experience with Always on High Availability solution.
• Experience using Windows System Task Manager to manage CPU/Memory resources in an environment of multiple instances of SQL Server
• Experience with SQL Server Database mirroring configuration and maintenance.
• Experience with implementing, configuring, troubleshooting and maintaining Log Shipping on very scale databases
• Experience in creating SQL SERVER functions and stored procedures using T - SQL.
• Experience with performance tuning
• Solid experience in Eliminating Blocking issues, performance monitoring with Activity monitor, SQL Profiler, Performance monitor, Database Tuning Advisor, DMVs and DMFs, SQL Diagnostic Manager.
• Experience in SQL SERVER 2005/2008/2012/2014 database cloning
• Experience with index tuning, index management, and statistics.
• Experience with High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server: Clustering, Replication, Log shipping and Database mirroring.
• Experience working in operational 24x7 environment
• Experience with large volume data extraction, transformation and loading (ETL) logic and tools.
• Experience with cross-platform database migration and database instance consolidation.
• Experience with periodic instance upgrades; applying patches and hotfixes.
• Configure and support SSIS and SSRS for 2005, SQL Server 2008 R2, SQL Server 2012, 2014 and 2016.
• Troubleshoot databases and custom application issues for 2005, SQL Server 2008 R2, SQL Server 2012, 2014 and 2016
• Experienced in working with end users to define, implement, and maintain their reporting requirements.
• Implemented SQL user security model using Active Directory groups.
• Experienced in the design, coding, testing and implementation of high volume transactional (OLTP) SQL databases instances.
• Experience with database Architecture and Data Modeling
• Develop and document SQL coding guidelines.
• Schedule, verify, and audit database backups and restores using native SQL or Red Gate backups.
• Personal computers and SANs
• 8-year experience Information Technology
• Generate the weekly, monthly, and quarterly report by using SQL Standard Report.
• Create reports that ran daily for jobs running in SQL Server Agent.
• Experienced with monitoring and troubleshootingin 24x7 operations.
• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
• Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
• Vast experience with PowerShell
• High availability (Always on, Clustering, log shipping, Replication, mirroring)
• 4-year experience with third party tools like Golden Gate and Idera
• Expert at High Availability Solutions Log-shipping, Mirroring, Clustering.
• Report Building using SQL Server Reporting Services (SSRS)
• Data transfer across servers using SSIS packages.

TECHNICAL SKILLS:

RDBMS: SQL 2000, 2005, SQL 2008, 2008R2, 2012, 2014, 2016 Database Administration, Data Modeling, Replication, Log shipping, Enterprise Environments, Tuning, SQL Profiler, Clustering, SQL Server Reporting Services, Oracle 10g/11g, Oracle Enterprise Manager.

Operating systems: Windows 2000, 2003, 2008, XP, Vista, Windows 7, Windows 8, Windows 10, Windows Server 2000, 2003, 2008, 2008R2, 2012

Databases: Microsoft Access, Microsoft SQL Server 2016 Standard and Enterprise, Microsoft SQL Server 2014 Standard and Enterprise, Microsoft SQL Server 2012 Standard and Enterprise, Microsoft SQL Server 2008 r2 Standard and Enterprise, SQL Server 2005, Oracle 11g.

WORK EXPERIENCE:

Confidential

MSSQL DBA

Responsibilities:

• Carry out requirement gathering and analysis and design ER Diagrams and EER Diagrams
• Design, implement and administer High Availability solutions, (clustering, log shipping mirroring and replication)
• Provide 24/7 remote support to SQL Servers on customer sites of various companies to prevent downtime
• Writing, debugging, and tuning T-SQL and Stored Procedures for system performance
• SQL Server database physical model creation and implementation (data type, indexing, table design)
• Setup and administering SQL Server Database Security environments using profiles, database privileges and roles to prevent data theft and increase data integrity
• Database maintenance, replication and tuning
• Lots of Migration of systems data from different databases and platforms to MS-SQL databases
• Migration between servers
• Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery in managing clusters of SQL servers
• Designing, Implementing and maintaining database schema, entity relationship diagrams, data modeling, tables, stored procedures, functions and triggers, constraints, indexes, functions, views, rules, defaults and complex SQL statements.
• Generate complex stored procedures and functions for better performance and flexibility
• Ensure database performance monitoring and tuning is regularly accomplished
• Design backup and restore strategies and Disaster Recovery solutions
• Create logical and physical data models based on approved business requirements
• Implement security policy design for current and new applications
• Coordinate team meetings with groups for new design/strategies
• Create database design for new projects support
• Responsible for maintenance, Backup & Recovery, testing, alerts (job failures, database & server capacity, etc.), and database integrity checks
• Review logs, update database statistics and index management
• Troubleshoot application performance issues, database maintenance & configuration, patching, and upgrading
• Security, auditing, configuring, documenting, enhancement & corrective changes, emergency changes
• Participate in DBA On-call monthly and document environments and processes where applicable
• Work with other DBA team members and various application teams
• Generate Health check report monthly.
• Auditing systems and developing standards and implementation of best practices for performance and clarity
• Coordinate change review meetings and facilitate in the management of incidents according to SLAs
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance
• Designed and implementing comprehensive Backup plan and disaster recovery strategies
• Migrating SQL Server 2000 databases into SQL Server 2005 as well as more recent versions (2008, 2008R2, 2012, 2014 and 2016).
• Recovering the databases from backup in disasters.
• Set up and Implemented and monitored different High availability solutions (Log-shipping, Mirroring, Clustering and Always On HA).
• Analyze long running slow queries and tune the same to optimize application and system performance.

Confidential

SQL Server DBA

Responsibilities:

• Participated in the data warehousing of major deployment and Migration projects.
• Part of a DBA team ensuring 24 x 7 production support of all corporate databases.
• Perform backups of all SQL servers 2000/2005/2008/2008 R2/2012 daily, weekly and monthly
• Ensure database server security by implementing applicable security patches and maintaining appropriate security measures per company standards.
• Production DBA-Maintained the health and general maintenance of production Databases
• Worked on a migration project using SSIS and SQL server migration assistant.
• Perform diagnoses and performance tuning when needed using DMV and functions
• Review SQL code for security, standards and optimization.
• Monitor and maintain database performance; identify and recommend areas that need improvement.
• Automate and manage maintenance jobs that ensure stability and performance of database servers.
• Own, track and resolve database related incidents and requests, fulfill requests and resolved incidents within SLAs, reviewing service related reports: database backups, maintenance, monitoring on a daily basis to ensure service related issues are identified and resolved within established SLAs
• Helped Design, maintained and controlled the corporate database and data dictionary.
• Established and enforced all database standards.
• Analyzed all informational requirements of new or production systems and develops database specifications.
• Work with a team of DBAs to implement and maintain database mirroring
• Established and enforced controls to ensure database integrity.
• Reviewed overall physical database structures for data integrity, quality, recoverability, maintenance and space requirements
• Experience in creating, monitoring, backup, recovery and tuning SQL Server databases in a multi-platform environment.
• Set up and Implemented and monitored different High availability solutions (Log-shipping, Mirroring, Clustering and AlwaysOn HA).
• Experience with logical and physical data models and SQL objects
• Converting data between different database platforms to SQL Server.
• Clustering both on windows levels and on the SQL server level
• Experience writing stored procedures that access SQL server Database tables for optimal performance.
• Performance Tune or optimize applications/ETL processes as and when require
• Recommend, design and maintain SQL code along with developers to support development of custom products and services.

Confidential

SQL Database Administrator

Responsibilities:

• Provided technical assistance to computer user in classroom networks while answering questions and resolving
• Technical issues for clients in person, via telephone or electronically
• Served in SQL DBA capacity.
• Completed on a daily basis over 20 service requests regarding from our internal ticketing system.
• Oversaw the daily performance and maintenance of 30 servers and over 70 SQL Server instances.
• Performed system imaging using Norton Ghost 12.0.
• Analyzed long running slow queries and tuned same to optimize system performance.
• Set up SQL Server configuration settings.
• Monitored database servers using Idera third party software.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Data Analysis and Data Profiling as required
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Migrating SQL Server 2000 data bases into SQL Server 2005.
• Recovering the databases from backup in disasters
• Worked with SQL Server tools Like Enterprise Manager and SQL Query Analyzer.