SUMMARY

• Ability to ensure corporate databases are protected against the loss or misuse of information and designing backup/recovery strategies.
• Responsible for troubleshooting and problem solving of SQL Server with RCA.
• Experience with multi - instance SQL servers
• Responsible for improvement and maintenance of the databases to include release rollout and upgrades.
• Experience managing multiple MS SQL RDBMS on web-based transactions.
• Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery and managing clusters of SQL servers
• Maintenance and tuning of database and replication.
• Experience with setup and administration of SQL Server Database Security environments using database Privileges and Roles.
• Experience installing, configuring, upgrading database software including HADR configurations, High Availability (HA) and Disaster Recovery
• Experience in SQL server performance tuning, change tracking and query monitoring
• Provide SQL Server database physical model creation and implementation (data type, indexing, table design).
• Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
• Third party tools worked with includes but not limited to: Redgate, Quest LiteSpeed, Idera, SQL Toad, SCOM, SCCM, Autosys, BMC Remedy, ServiceNow, Jira.
• Hands-on experience with cloud platforms including modern databases.
• Good leadership and interpersonal skills, coupled with a proven ability to manage a team in providing excellent customer relation and achieving growth.
• Capable of communicating effectively in spoken and written English.
• I am a motivated, energetic and goal focused professional with a consistent desire to succeed.
• Self-starter with a drive to see task through to completion and to meet deadlines.

TECHNICAL SKILLS

RDBMS: SQL 2005, SQL 2008/2008r2, SQL 2012, SQL 2014, SQL 2016, and SQL 2017. Enterprise Environments, tuning with SQL Profiler/Extended Event, Clustering, SQL Server Integration Services, Mirroring, SQL Always On AG

Operating Systems: Windows NT/ 2000/2003/2008/2008 R2/2012R2, 2016, 2019 (GUI and Core) and Linux

PROFESSIONAL EXPERIENCE

Confidential

Consultant SQL Server DBA

Responsibilities:

• Migrated Databases from SQL Server 2012 and SQL Server 2014 legacy application to SQL Server 2016 with deprecation of clustering and mirroring HA solutions and replace with Always On solution.
• Worked with table partitioning (SQL Server 2008) mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
• Worked with Transparent Encryption, table compression, database compression and merge statements using SQL server 2008.
• Used Policy Based Administration feature (SQL Server 2008 R2 and 2012).
• Worked with 'insert' commands to programmatically INSERT data if it does not exist or UPDATE the data if it does all in 1 set of logic (SQL Server 2008).
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2012 and 2014, 2016 and 2017.
• Setting up and monitored transactional replication, Database mirroring on Production and QA servers.
• Worked in Active-Active Cluster environment as a high availability solution.
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Extensively used TSM lite speed backups.
• Expert in Performance Tuning of Stored Procedures.
• Checking Database Health by using DBCC Commands and DMVS.
• Monitored and modified Performance using execution plans and Index tuning.
• Experience in Database security and integrity planning.
• Used database mirroring for synchronization of databases.
• Prepared Documentation for Disaster Recovery plan.
• Designed Data Integrator jobs with Error Handling and email notifications.
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Test servers.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Performed the migration of SQL Server 2012 to SQL Server 2016, SQL Server 2014 and 2016 to SQL Server 2017 and 2019.
• Provide 24x7 production support for SQL Server databases on standalone and Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.
• Worked extensively with Query analyzer and profiler for tuning queries using variable for characteristics and query costs
• Configured the servers on 32 bit and 64 bit clustered and standalone server environments
• Installed and maintained 2-Node (Active- Active-Active) Clustering as a High availability solution.
• Responsible to Monitor and troubleshooting Log Shipping.
• Implemented and maintained Database mirroring as a Disaster Recovery Solution.
• Migrated legacy databases with upgrade from SQL 2005 and 2008R2 to SQL 2012 and SQL 2014 with Always-On configuration.

Confidential, Houston TX

Contract SQL Server DBA

Responsibilities:

• Installing SQL Server with standard access privileges service account to improve security and to attain high ratings in SOX audits.
• Installed, configured SQL Server 2008R2 Clustering on Microsoft Clustering services (MSCS) for Active-Passive and Active-Active Cluster Nodes.
• Involved in Analyzing and Upgrading SQL Server 2000 test and production servers to SQL Server 2008R2.
• Have experience on SAN and RAID levels and building SQL Cluster servers on SAN Environments.
• Perform SQL Server service pack and Windows Service pack updates across enterprise production environment.
• Designed robust backup strategy and implemented comprehensive Backup plan using Native SQL and Lite Speed.
• Resolved and tweaked memory pressures caused during production release.
• Worked with customers on Application rollouts and server migrations.
• Migrated legacy databases with upgrade from SQL 2005 and 2008R2 to SQL 2012 and SQL 2014.
• Experience in supporting Very Large databases (VLDB) and troubleshooting related problems.
• Strong experience in mentoring team members and writing documentation.
• Troubleshoot performance problems and fine-tuning of databases.
• Experience with rebuilding indexes and statistics update at regular intervals for better performance.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Responsible for DB Refreshes from Production to QA/Staging/Development based on user requests or Application team needs including data cleansing
• Provide 24x7 production support for SQL Server databases on standalone and Clustered Servers with sizes ranging from 100s of GB to 3.8 TB to achieve maximum performance and uptime in production environment.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Implemented and Scheduled Replication process for updating our parallel servers.
• Experience in Batch processes, Import/Export, Backup, Database Monitoring tools and Application support.
• Configured and maintained SQL Server 2012 and 2014 Always-On for HA and DR as clients BC strategy
• Developed & executed scripted changes requests in accordance with change control procedures.

Confidential

Project Manager (IT)

Responsibilities:

• Accomplished information technology staff results by communicating job expectations; planning, monitoring, and appraising job results; coaching, initiating, coordinating, and enforcing systems, policies, and procedures
• Maintained organization's effectiveness and efficiency by defining, delivering, and supporting strategic plans for implementing information technologies
• Directed technological research by studying organization goals, strategies, practices, and user projects
• Completed projects by coordinating resources and timetables with user departments and data center
• Verified application results by conducting system audits of technologies implemented
• Preserved assets by implementing disaster recovery and back-up procedures and information security and control structures
• Recommended information technology strategies, policies, and procedures by evaluating organization outcomes; identifying problems; evaluating trends; anticipating requirements
• Accomplished financial objectives by forecasting requirements; preparing annual budget; scheduling expenditures; analyzing variances; initiating corrective action
• Maintained quality service by establishing and enforcing organization standards
• Maintained professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; participating in professional societies
• Contributed to team effort by accomplishing related results as needed

Confidential

Construction Site Engineer

Responsibilities:

• Handled both phone and email enquiries related to Customers shares accounts.
• Set out detailed works as per the contract drawings
• Performed Setting out, levelling, and surveying the site
• Main technical adviser on construction site for subcontractors, crafts people and operatives
• Resolved all unexpected technical difficulties and other problems that arouse at any time
• Produced procurement schedules for the jobs and liaised with the procurement department to ensure site had adequate resources to complete the tasks
• Plans checking, drawings and quantities for accuracy of calculations
• Produced site diaries, accurate records, drawing registers and allocation Sheets
• Ensured that all materials used, and work performed are as per quality and specifications
• Managed, monitored and interpreted the contract design documents supplied by the client or architects
• Established safe working cultures and practices among workers on site
• Liaised with consultants, subcontractors, supervisors, planners, quantity surveyors and the general workforce involved in the project
• Carried out day-to-day management of the site, including supervising and monitoring the site labor force and the work of subcontractors
• Oversaw quality control, health and safety matters on site