Sql Server Database Administrator

GALVANI F. TEKE **********@*****.*** 202-***-****

MS SQL AZURE SQL DATABASE ADMINISTRATOR

PROFESSIONAL SUMMARY

Six years experienced SQL Server Certified Database Administrator adept at maintaining database integrity and security by developing policies and procedures. Highly skilled in orchestrating high availability and disaster recovery solutions by implementing failover clustering, log-shipping, mirroring, replication, Always On, analyzing performance and tuning data. Proficient in reviewing database designs and documents for providing suggestions for enhancement base and optimal performance of databases, ETL, Windows Clustering. Ensuring security by implementing TDE, DDM, Always Encrypted & Auditing. Patching and DB upgrades and Managing Relational Databases on Azure, Virtualization – Hyper-V, Build Domains Controllers and Active Directories, strong experience with sql server migration from older to newer versions. Managing of large size databases.

SKILLS

SSAS SQL DBA SQL Replication SQL Server Profiler SQL Server Integration Services Technical Documentation Metrics Communication SQL Server Monitoring Inbuilt Reporting Database Mirroring Log Shipping Replication Traditional Failover Clusters Data Warehouse PowerShell Azure Cloud T-SQL Scripts Procedure Documentation SSIS SSRS RDBMS (Relational Database) SOLAR WINDS DPA

WORK EXPERIENCE

MS SQL Server/Azure SQL DBA 2021 – PRESENT

Wipro Limited . – Plano Tx

•Install and configure Microsoft SQL servers, Azure VMS, periodic systems, security patches, and related products.

•Implement and maintain databases security, including creating and maintaining users and roles. Perform database maintenance and application/database performance tuning, protecting the organization’s data through scheduled backups of data assisting network operations centers team in scheduling and restore activities.

•Maintain and monitor all databases instance, Cloud and on premise to ensure system availability. Provide Tier 2/ Tier 3 technical support and general consultation and deployment activities across technology design teams.

•Create and maintain database documentation and standards. Perform database capacity planning, data migration, SQL scripting. Build and deploy SSRS.

•Analyze and review the database components of vendors’ software packages.

•Manage SQL server integration services and ETL to deploy and troubleshoot store procedures.

•Utilize IAAS and PAAS Azure services (cloud infrastructure), creating and managing virtual machines, migrating databases, and automation of processes. Ensure transparent data encryption, set always on, and create and manage users, azure storage accounts, and resources. Developed single database and eclectic pool using platform as a service, managing databases, automating, and deploying scripts, creating, and managing users, and performance tuning in azure.

•Migration, ensure good Disasters and recovery solutions, migrating databases from one service to another and migrating from on premise to cloud. Develop disaster recovery solutions, such as suitable backups and developing effective restores strategies.

•HADR solutions such as Always on, replication, mirroring, and implementing high availability solutions, including always on technology, log shipping, and mirroring technology.

MS SQL Server Database Administrator SEPT 2020 – SEPTEMBER 2021

T&M GLOBAL – Houston, TX

•Designed, developed, tested, deployed, and maintained databases, database objects, database security, backup database, good recovery solutions, ensure high availability, and task automation on production environment.

•Supervised and upgraded SQL Server 2008 servers to SQL Server 2016 with both in-place and side-by-side upgrades for new client applications. Followed up and changed management processes to maintain the accuracy of statistics. Instituted the maintenance and support of replication and log shipping

•Created various maintenance plans for index fragmentation and backups to automate the team's tasks and ensure better systems’ health, performance, and operations according to company policies and regulations.

•Identified existing systems that are candidates to be enhanced or modernized though detailed analysis of the use and design of current database structures.

•Developed rules and guidelines for the development of SQL objects. Optimized indexes and tables to increase the performance of scripts in SQL servers. Created and maintained database dictionaries and schema documentation, attending to user needs and adhering to compliance.

•Designed and deployed data table structures, triggers, functions, stored procedures, and views. Created queries and reports for day-to-day automation processes.

•Fulfilled data requests and resolved database access and performance issues, architecture, and database development, ensuring integrity.

•Interfaced with developer, network, virtualization, storage, and systems operations teams to resolve problems with applications and database systems during transaction processing.

•Troubleshot performance issues, tuned administration, developed strategies, maintained databases, and recommended business requirements.

•Oversaw Microsoft SQL server, query tuning lifecycle, performance tuning, and information gathering for data management reports.

•Used power shell to migrate and configure SSIS packages from one server to the other. Applied VISUAL Studio to build and deploy SSRS reports.

SQL DBA MAY 2019 – August 2020

First Data Corporations Atlanta

•Designed, assessed, implemented, and maintained all facets of databases, including objects, security, backup database, and recovery solutions to ensure high availability and task automation on production environment.

•Migrated databases utilizing methods such as backup and restore, detached and attached.

•Applied PowerShell scripting for the automations of task, SQL Partitioning of tables, and indexes.

•Installed, configured, and maintained SQL server databases from 2008 /2019 versions.

•Guaranteed appropriate performance tuning and monitored environment using both in-built and third-party tools to ensure suitable workflow in clustered environment and provided weekly status reports.

•Implemented high availability solutions such as replications, mirroring, and log shipping, continuously on availability group and data management reports.

•Supported technical architecture and applied accurate HA/DR strategies.

•Diagnosed root cause analysis to help in problem resolution and coordinates projects.

•Coordinated with security compliance, support services and developed reports.

MS SQL DATABASE ADMINISTRATOR JUNE 2017 – MARCH 2019

ALLSTATE INSURANCE– Charlotte NC

•Maintained data back-up for recovery in the event of disasters within database security.

•Upgraded SQL Server 2005 servers to SQL Server 2016 with both in-place and side-by-side upgrade for new applications within the company.

•Configured and setup availability groups in a 3-node windows cluster environment where two were in-house and one in a data center for disaster recovery.

•Handled SQL Server installation, configuration, security, and maintenance following best practices, reliability, maintenance of databases.

•Employed SQL Server Profiler, Extended Events, Query Store, and Database Engine Tuning Advisor (DTA) for performance and other third-party monitoring tools.

•Coordinated with developers when writing complex queries and schema refinement. Maintained database response times in high impact production environments by developing automated alert jobs and operate according to policies and regulations.

•Prioritized, responded to, and executed tasks in a high-pressure environment, designing, configurating, upgrading MS SQL support production systems.

•Migration and application of Windows and SQL Patching during scheduled database downtimes after hours to ensure databases were current in virtualized environments implementation. Defined vigorous backup and recovery strategies and capacity planning following the company’s Recovery Point Objective (RPO), Recovery Time objective (RTO), and the Retention policy, supporting SQL database architecture and technical support directory. Learned emerging technologies, operating systems, federal regulations, system support, and information technology.

•Recommended and implemented data security by creating users and assigning permissions based on the minimum level of database access the user would need, with tools like Always Encrypted, Transparent Data Encryption (TDE), and Dynamic Data Masking (DDM) to secure clients sensitive data.

EDUCATION CERTIFICATIONS

B. Sc. In Computer Info System

Virginia Union University – Richmond VIrginia

Contact this candidate