Galvani Teke

**** ******** ******* **,

Houston, TX 77077. Phone:202-***-****. Email: adnnu8@r.postjobfree.com

Professional Profile

Enthusiastic administrative professional with over six plus years of experience in MS SQL Database administration, in installation, configuration, upgrade, migration using ETL(SSIS), performance tuning, patching, high availability, backup and recovery, Automation using veeam, SQL scripts, PowerShell, Sql Server Agent etc., Experience include all aspects of SQL SERVER Database (2019, 2017, 2016, 2014, 2012 and 2008R2 and 2008) Also have working knowledge of the Azure Platform from configuration to implementation using

VM’S and VMware V6.0, have also worked with different ticketing systems such as SERVICE NOW and service desk

Good communications and problem-solving skills. Very dependable and reliable. Citizen of the United States. No sponsorship required now or in the future.

Skills

•Understanding of Data Structure and Algorithms.

•Analytics and problem-solving skills

•SQL Server DBA, Data Security, SQL Profiler

•Performance Tuning, Patching, Upgrade, Scripting

•Migration, ETL(SSIS), Backup and Recovery

•Good understanding of Waterfall and Agile implementation methodologies

•Fair understanding of SDLC.

Professional Experience

ALLSTATE INSURANCE, Charlotte, NC July 2018 to Present SQL SERVER DATABASE ADMINISTRATION

•Installing of SQL Server databases instances in development, Quality assurance, and production environments

•Create and manage database objects such as tables, store procedure, indexes, and functions.

•Hands on in Troubleshooting and researching on error codes using Extended Events, Sql Profiler, and Performance monitor, Query Store, Sentry one etc.

•Run daily maintenance jobs and deployments

•Create users and grant the privileges.

•Work with the server teams to build and maintain Servers

•Do data masking using TDE and or Red gate • Work on SQL migration, upgrade, and patching.

•Create and manage Backup/Restore (Full, Deferential and Log Backups)

•Creation of Indexes to enhance Performance

•Database Performance evaluation using Utility Control Point (UPC)

•Developing ETL packages using SSIS and Bulk-loading utilities

•Resolved technical and complex database issues before they impact production systems.

•Developed and maintained store procedures, advance queries, triggers, views, indices, and functions for databases.

•Execute daily maintenance jobs. Automate daily jobs using SQL Server agent jobs, VEEAMS, RUBRICS and or SQL SAFE

•Participate in 7/24 rotating on-call nights and weekends as needed

•Configures and maintain High Availability solutions such as Replication, Always on AG group, mirroring, Log Shipping, for disaster Recovery

•Capacity planning, SQL SERVER Clustering, database security configuration, and database continuity

•Good knowledge of High Availability (HA), Always on and Disaster Recovery (DR) options for MSSQL Server

•Experience on high Availability/ Disaster Recovery (HADR) Solutions; Failover clusters and Always On Availability Groups, Replication, log shipping and mirroring.

•Responsible for applying database services packs and other security and non-security patches based on company’s approved maintenance schedules and downtime

•Worked on Microsoft AZURE (public and Private) Cloud to provide IAAS support to clients

•Actively involved in Trouble shooting using tools like Query store, system monitor,

DMV’S/DMF’S

•Created Virtual Machines through Power shell Scripts and Azure Portal

•Manage and Create Storage accounts and affinity Group in AZURE Portal

•Use VM’S and VMware to create Virtual Network, Subnets and End points in Azure portal

•Helped Clients in resolving Always on AG GROUP problems. Initiated communication with clients to troubleshoot error codes, performance issues in backup jobs and always on AG Group projects using tools like Performance monitor, profilers and DM

•Converted existing virtual machines from Standard to premium storage accounts, patching and validation of Virtual Machine in Azure

•Monitored Azure infrastructure through system center operation manager (SCOM). Migration of huge amount of data into AZURE using AZ COPY, migration Assistant and SSIS

•Used AZURE ACTIVE DIRECTORY to create and assign users/roles and to grant permissions and to create an additional security layer by using a multifactor authentication

•Migrated my servers from 2012/2014 to sql 2016 and did some patching on sql 2019

•Create firewalls to act as a security layer. Hands-on experience with Installation/Troubleshooting.

MARATHON OIL, Houston, TX Aug 2015 – May 2018

SQL Server DBA

•Responsible for supporting and managing over 100+ SQL Server databases running on multiple instances and ensuring their performance, availability, and security.

•Managed production and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.

•Provided trend analysis to the service management team to enable them to make informed decisions regarding resource management

•Upgraded SQL Server 2008/2012 to SQL Server 2014/2016 following a detailed Upgrade Project Plans, which involved Successful testing of upgrades plans with the application team before cutover, and rollover to critical Production databases

•Managed multiple SQL Server instances in Active/Active and Active/Passive clusters.

•Responsible for implementation and release of database changes submitted by development team

•Migrated my servers from 2012/2014 to sql 2016 and did some patching on sql 2019

•Troubleshooting production issues and errors using Query store, performance monitor, Extended event, and profiler

•Used SSIS AND Bulk Copy as ETL tools to move data from one location or from one drive to another

•Involved in installation, configuration, and upgrading of MS SQL Server

2008/2008R2/2012 /2014/2016 servers

•Involved in Database upgrades and Migration of SQL2008R2/2012 to SQL2016 and coordinated all Upgrade activities

•Worked on SQL server clustering to provide an active and passive node, SAN storage with RAID 10 implemented on Dell servers, VIP pool to manage the IP address of SQL servers.

•Performed data transfers between various servers using BCP, Bulk inserts, import and export Wizard for developer requests, Environment Migrations, Backing up and Archiving Data for various business requests

•Exported and imported data from text files and Excel to SQL Server using bulk insert and BCP utility

•Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications

•Security Administration by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granted privileges to users and groups

•Backup and recovery of production databases and Monitor data and log growth, Jobs, Alerts, disk usage and cleanups using 3rd party tool Lite speed

•Prepared documentation for capacity usage factor data validations and work summary for capacity usage factor calculations. Environment: MSSQL Server

2008R2/2012/2014/2016, MS Access, Windows server 2003/2008/2012, DTS/SSIS, SSAS, Visio, Lite speed, VSS 6.0, Erwin, SQL Diagrams, Fog light. Index tuning wizard, SQL Profiler, Query Analyzer, Enterprise Manager SQL SAFE etc.

Education

Virginia Union University, Richmond, VA Aug 2012 – Dec 2015

Bachelor’s in computer information systems (Microsoft SQL Server 2012/2014)

Certifications

Successfully completed Microsoft certification exams:

• 70 -461(Querying Microsoft SQL Server 2012/2014 • 70 – 462 (Administering Microsoft SQL Server 2012/2014

Currently preparing for 70 – 463 - Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 which will qualify me for the Microsoft Certified Solutions Associates Certification in SQL Server. Also working on AZURE 104.

Additional Skills

•Quick Learner

•Adaptive and Friendly

•Ability to work under Pressure

References

Both personal and professional references will be provided upon request.

Contact this candidate