Resume

Sign in

Security Maintenance

Location:
Houston, TX
Posted:
April 25, 2021

Contact this candidate

Resume:

SQL SERVER DATABASE ADMINISTRATION

Name: Hippolyte Wantou

Email: adlyac@r.postjobfree.com

Cell: 346-***-****

Address: Houston, Texas

Green Card Holder

Dedicated and hardworking SQL Server Database Administrator with over 5 years of experience in supporting and managing database applications. Successfully managed database across multiple servers in production, development, staging and testing environments. Committed to ensuring complete database organization and security. Excel at database modification and improvement. Exceptional analytical, problem-solving, and communication skills. Excellent attention to details and experience with numerous types of database software's. Ability to work well on a team and individually.

Administer SQL SERVER 2016/2014/2012/2008

Database Installation and configurations

Experience in deploying SQL SERVER HADR (log shipping, always on, mirroring, failover cluster instances

SDLC Migration/Upgrades/Patching

Backup/Restore

Performance Tuning /Troubleshooting

Database security

Task automation

SQL SERVER DBA

Houston, TX

Global Solution

Technology

June 2018 – March 2021

Responsibilities:

Experience with designing, development and maintenance of SQL Server environment for Corporate and Investment Banking applications on the enterprise scale

Installation/ configuration of SQL SERVER 2008&R2, 2012,2014,2016,2018 in both UAT/DEV/PROD servers.

Perform and Monitor daily tasks such as Backups & Restores, maintenance jobs, handling developers’ requests and user's permissions etc.

Implemented and Maintenance of all (HA) High Availability configurations like Log Shipping, Database Mirroring, Replication and Failover Clustering as a part of HADR Plan.

Configure/setup Server Properties like Memory Options (AWE switch), Database Settings etc.

Checking Database Consistency/health by using DBCC &Commands DMVs at regular intervals.

Actively participate in all phases of system development life cycle including planning and analysis, design, development, and testing

Maintain application performance & scalability with a focus on (PTO) Performance Tuning & Optimizing SQL queries, table design, indexing, query plan analysis, databases & SQL servers

Provide support for architectural designs to enhance complex subsystems like analytics engines

Design and implement Continuity of Business solutions, data warehouse solutions for SQL Server databases including replication strategy and Active-Active and Active- Passive clustering

Create alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breaches.

Export/Import data from other data sources like flat files using SSIS/DTS packages.

Setup Database Security and maintain accounts and access levels by creating suitable Logins and Roles and assigning object level permissions.

Manage Disk space, Memory, and User Connections.

Schedule and monitor maintenance activities including database consistency checks and index fragmentation.

Extensively work on Performance Monitor, SQL Profiler, DMVs, DMFs and DTA to tune the databases, servers and query tuning.

Schedule weekly jobs and Maintenance tasks for better performance and created alerts with Database Mail SMTP.

Configure Database Maintenance Plans for Backups, Re-indexing, and Reorganization of Indexes, Cleanup History, and Update Statistics.

Relocation/migration of Databases from one server to another using attach and detach database tasks or backup and restore.

Experience in deploying/administering SQL SERVER (SAAS,PAAS) in AZURE cloud.

Identify the I/O and memory bottle necks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor/profiler, Dynamic Management Views

(DMV) and handling them by implementing better Query Execution plans.

Rebuilding indexes with different fill factors and updating statistics.

Configured SQL maintenance plans, jobs, sending alerts using database mail.

Work with system administrators for creating/modifying/user/group accounts in Windows Active Directory in order to authenticate SQL server users through domain group/user accounts.

Monitoring Event Viewer, SQL Error logs, Log File Viewer for Software and hardware related errors.

Setup Linked Server, which allows access to the distributed, queries against OLE DB data sources for EXCEL, MS ACCESS and Text files and running the Batch Processes.

Monitor disk configuration and storage allocation to support application enhancements.

Recover System and User databases from suspect mode, sizing Temp database.

Setup & configure Server and Database properties and various options Environment: MS SQL Server 2008/20012/2014,2016 64 bit, Enterprise, Windows server 2008/20012/2016 64 bit, SSMS, Foglight, Veam, SSMS Business Intelligence Development Studio- SSIS, SSRS, Performance Monitor, Extended events, SQL profilers, Activity Monitor, Perfmon, Azure SQL SERVER DBA

Dallas TX

(Contract with Boeing) February 2015 – June 2018

Responsibilities:

Expertise experience in installing new instances of SQL Server 2008 R2, 2012 AND 2014 on Microsoft Windows Server2012 R2 and following best practices.

Monitored and administered SQL Instances on standalone servers and Cluster environment

Highly experience on handling VLDB such ranging from 500Gb to 3T on different VMs which added up to a total of 50T both in UAT/DEV & PROD environments.

Installed and administered 2 Node cluster on Microsoft Windows Server 2012 R2 Enterprise Edition on SAN storage.

Strong experience in Database Optimization and Tuning, Backup/Restore, Troubleshooting, and Data Import/Export.

Expertise in designing and implementing the processes and standards for database systems recovery and back-up checks as well as user performance and data security.

Updated database systems by reviewing, planning, testing and installing database security patches and service packs.

Expertise in troubleshooting SQL Server Agent jobs, Error Logs, Windows Logs to resolve failure job component.

Extensive experience in monitoring and making recommendations for performance improvement in hosted databases, this involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics.

Strong experience using DMVs, DBCCs and SPs from SQL Server 2008R2 to 2014 for checking database health and performance.

Expertise in monitoring performance using SQL Profiler, Activity Monitor, Perfmon in order to find locking, blocking and deadlock issues.

Expertise in planning and managing SDLC projects such, patching, hot fixes and service pack upgrades and migrations.

Experienced in SQL Server migrations of various versions. Planned/Designed and migrated 7 PROD Database servers, 6 DEV DB servers, 5 UAT DB severs from SQL SERVER 2008 to SQL SERVER 2014 used both in place and out place upgrades.

Experience with dealing with ITOPS change review meetings for changes to be approve for implementations on PROD environment.

Experienced in recovering the databases from disasters and implemented Point-In-Time Recovery solution.

Analyzed and defined capacity planning for maintenance of the different Database Backups and Restore scenarios

Participated in designing, testing and implementing an enterprise Disaster Recovery Plan.

Set up linked servers and troubleshooting any issues related to ODBC connectivity.

Automated daily tasks including backup and restore tools by using SQL Server 2008/2008R2/2012/2014 native SSMS tools.

Experienced to work in coordination with different Teams (like Network Team, Windows Admins, Storage Admins, and other application Teams) as well with Stakeholders and customers.

Experienced with High Availability solution such as Always On, Cluster, Mirroring and Log Shipping.

Experienced in rewriting and restructuring store procedures and views with T-SQL.

Expertise in writing technical reports for the management and for other of Production support.

Provided 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.

Environment: MS SQL Server 2014/2012/2008R2, T-SQL, SSIS, Asana, Red-gate, LiteSpeed, SQLProfiler, Performance monitor, BCP, Replication. Log Shipping, Mirroring, Clustering, Windows Server 2012R2, JavaScript, MS TFS, MS-Access, SharePoint 2010, SolarWinds, and PAL tool.

EDUCATION

Bachelor’s degree in Computer Science University of Yaounde I Languages: English and French



Contact this candidate