Post Job Free

Resume

Sign in

Database Administrator Data Migration

Location:
Bridgeport, CT
Posted:
October 09, 2023

Contact this candidate

Resume:

THUANY LEITE

DATABASE ADMINISTRATOR

Bridgeport, CT

Mob: +1-475-***-****

adz9ea@r.postjobfree.com

PROFESSIONAL SUMMARY

• IT Professional with over 5 years experience specialist in almost all Microsoft Infrastructure products like Windows Server (all versions), SQL Server (all versions since), AWS, Hyper-V, Backup, Always On, Migration and others.

• Skills in management and relationship with internal staff, consultants and contractors. Deep Network and SQL projects and deployment.

• Microsoft Certified Professional since 2016 currently having the title of Microsoft Technology Associate (MTA)

• Performed DBA function to manage implement database security, and upgrade to SQL Server 2014/2016.

• Worked on SQL Server 2012 to SQL 2016 migration for production environment, experience using Data Tools

• Developed SQL paging system for different issues such as drive space, deadlocks, SQL Job failure, SQL Job Stuck, expensive queries.

• Tune existing store procedures by putting indexes and improving complex queries performance by using better logic with less reads and CPU usage.

• DR (Disaster Recovery), HA (High Availability) and Point-In-Time Recovery planning and implementation.

• Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.

• Designed and Supported customer migration to AWS RDS for MSSQL server.

• Developed and implemented several SQL scripts and processes to enhance management of databases. TECHNICAL SKILLS

Operating Systems: Windows 2003, 2008R2, 2012R2 and 2016 RDBMS: SQL Server 2008 – 2019 DB2 (basic) and Oracle (basic)

SQL Server Tools: Management Studio, Visual Studio, Enterprise Manager, Query Analyzer, Performance Monitor, Database Tuning Advisor, Log Shipping, Server Network Utility, SQL Profiler, Index Tuning Wizard, SSIS, SSAS, SSRS, Microsoft Clustering Services (MSCS), Database Mail, Alert, Notification, SQL Server Management Studio, SQL Server Agent.

Report Tools: MS Reporting Services (SSRS), Report Server (configuring, managing, creating, and deploying reports).

Data Migration: SSIS, Data Migration, SQL Loader, SSMA (SQL Server Migration Assistance).

CERTIFICATIONS

• MTA - Microsoft Technology Associate

• AWS – Backup

PROFESSIONAL EXPERIENCE

Client: KYNDRYL, São Paulo Area, Brazil Nov 2021 – Aug 2023 Role: Pleno SQL Database Administrator

Responsibilities:

• HA planning and implementation for critical environments

• SQL Server Database administration

• AWS Projects (RDS and S3)

• Azure Projects (Azure SQL Database, Azure Database Migration Service.)

• Backup and Restore Projects.

• Windows Server administration (AD FS, DNS, DHCP, WSUS, Nano Server, IPAM)

• Implementing and Maintaining Log Shipping, Windows Failover Clustering, Database Mirroring, Always On as Disaster Recovery and High Availability solution.

• Troubleshooting SQL Server for database, application users respective and provide solution within timely fashion. Schedule SQL Server Agent Jobs, SQL Server across multiple Servers with automatic and manual execution.

• Involved in resolving Lock and Deadlock and Index Optimization.

• Performance tuning and system troubleshooting.

• Back up and Disaster Recovery

• Establish standards for documentation and ensure that all designs are documented.

• Implemented Always-On Availability Groups (AAG) and HA/DR Setup and Configuration

• Involved in the migration process – Stand Alone for Always On

• Created and Managed User Accounts, Log Management, Shared Folders, Group Policy Restrictions, etc.

• Administration of SQL Server running in AWS – RDS instances. Client: NPO SYSTEM, Belo Horizonte Area, Brazil Oct 2020 - June 2021 Role: SQL Database Administrator

Responsibilities:

• Working and supporting for SQL Server 2008 – 2016 managing, installing and configuring on Windows Server 2012R2/2016 environment.

• Managing account, creating login, mapping users for database and server level access as needed.

• Analysis, planning and implementation to restructure all Database and Storage environment.

• SQL Server Always On implementation

• Backup and Restore Projects.

Client: MSDB SIMPLIFIED IT, Belo Horizonte Area, Brazil Apr 2018 - Aug 2020 Role: Data Analyst

Responsibilities:

• Reports creation with Reporting Services

• FailOver Cluster Creation and administration

• SQL Server administration.

• Performance and Tuning of DataBases in SQL Server 2008R2/2012

• Disaster e Recovey

• Administration in DHCP, File Server, AD, DNS

Client: Group Software, Belo Horizonte Area, Brazil Apr 2016 - Aug 2017 Role: Help Desk Agent

Responsibilities:

• Ticket Management

• Customer Service to resolve app issues

• Access and SQL database

• System update management

• ETL Process Creation (Integration Services)

• Reports Creation with Reporting Services

EDUCATION

• Higher Education Information Technology, 2016 Feb – 2019 Dec VISA

• Green Card Holder

• Resident Permanent

• There’s no need sponsor to work.



Contact this candidate