SQL Server Database a

WILSON N. ETAMO

Database Administrator (US Citizen)

Email: *****.*****@*****.*** Phone: 240-***-****

Address: **** ********* **, ****** ** 20706

Overview

I am an experienced and result-oriented professional with over nine years of experience in Database administration, possessing a unique set of skills in Robotic Process Automation, Oracle and SQL Server database installation, configuration, administration, production support, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, always on, scheduling and automating SQL server jobs and documentation amongst others. A Problem solver with the ability to think creatively to achieve established objectives. Efficient in creating, building and managing teams to accomplish specific goals.

Skills:

With over nine years of experience in both Oracle and SQL Server Database Administration, Design, System Analysis, Testing, Development and Support of SQL Server 2017/2016/2014/2012/2008 in Production and Development Environments.

Experience in database administration and development activities such as Installation, Configuration, Database design & development, Data modeling, Backup & Recovery, Performance tuning and Query Optimization, Data Transformation Services, and Database Security

Experience working with SQL Server 2016/2014/2012/2008 versions. Hands on experience in SQL Server DTS and SSIS package administration, and deployment.

Extensive knowledge of Relational Database Management Systems (RDBMS)

Proficient in creating tables, views, triggers, SQL server agent jobs, etc

Assisted on the Adhoc-Query requests based on the requirement by using Joins, Sub Queries and Co-related Sub Queries.

Experience in implementing different types of Replication such as Snapshot and Transactional

Expertise in database Backup, Recovery and DR procedures. Developed and documented disaster recovery plans and backup and recovery strategies for production environment.

Experience in Batch processes, Import, Export, Database Monitoring tools and Application support.

Disaster Recovery planning and implementation – Database mirroring, Log shipping, Replication and Active Passive clustering.

Performance tuning, trouble shooting and monitoring using Performance Dashboard reports, Database Tuning Advisor, SQL Profiler, Server Side Trace, Dynamic Management views

Experience in providing 24 x 7 production support.

Configured NetBackup or tertiary data storage for long term retention

Configured Splunk for database monitoring and Cyber security enhancement

Excellent communication skills, organizing skills, highly punctual and an excellent listener.

Education

Bachelor’s in Engineering (Telecom, Signal Transmission and Radio Com.)

Associate degree (Senior Broadcaster) in Signal processing, Transmission and broadcasting

Tools and Technologies

Environment/ OS

Windows 2003, 2007, 2008 and 2010

Linux Red Hat, RHEL 6.x, 7.4.

RDBMS

SQL Server 2008, 2012, 2014, 2016 and 2017

Oracle 10g, 11g, 12c

Languages

T-SQL, SQL, shell scripting, power shell

Tools

SQL Server Management Studio, FogLight, WinSCP, Remote Desktop Connection (RDP), SQL Developer, Putty, MRemoteNG, VNC, Team Viewer, etc

Connectivity

Cisco VPN, Pulse, EndPoint Security, etc

Ticketing

Service Now (SNOW), IPM etc

Experience

Boeing Distribution Services – Silver Spring, MD

SQL Server Database Administrator 03/2018 - Present

Administering and maintaining large SQL Server 2016, 2014, 2012 databases with more than 100 million records in individual tables.

Responsible for Installation, Configuration and Administration of SQL Server 2008, 2012, 2014, 2016 and 2017

Upgraded and Migrated SQL Server from version 2012 to 2014 and 2016

Created and re-evaluated indexes and made modifications for better performance.

Table Partitioning for existing and new application databases.

Developed and implemented maintenance plans in both development and Production environments

Backups and Restore of different databases on SQL Server instance.

Creating databases and logins with permissions in SQL Server as per requested.

Performance tuning, trouble shooting and monitoring using Performance Dashboard reports, Database Tuning Advisor, SQL Profiler, Server Side Trace, Dynamic Management views

Assisted on the Adhoc-Query requests based on the requirement by using Joins, Sub Queries and Co-related Sub Queries.

Implemented Database Replication (Merge and Transactional).

Hands on experience in DR processes including Log shipping and Database Mirroring.

Implemented transactional replication for data refresh

Extensively used SQL Profiler and Query Tuning Wizard for troubleshooting

Created backup schedule for production, test and development servers.

Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.

Created standard documentation for DR testing and implemented them.

Experienced with creating logical and physical database design for development projects.

Experienced with improving SQL Server using windows performance monitor to improve the server performance.

Worked with developers to perform DB object updates with CC & DB restore requests

Involved in restore operations to refresh the data from production to test servers.

Experienced in troubleshooting production servers and complicated issues.

Configured NetBackup or tertiary data storage for long term retention

Configured Splunk for database monitoring and Cyber security enhancement

Managed a four nodes cluster in a highly secured system.

Booz Allen Hamilton – Charleston Digital Hub, SC

Database Administrator 06/2017 - 03/2018

Supporting the Veterans Benefit Management System (VBMS) development Project as a Senior DBA to meet the government’s request to reduce the overall time required to process a veteran’s claims.

Worked with other team members and contractors to create and test deployment packages and prepare development environments for major software development, testing and releases.

Supported developers, release management, data scientists and other DBA’s on various releases.

Documented the DEV environment software development activities and procedures.

Management of split stream code development and deployment in multiple environments

Perform database and schema exports on a regular basis.

Training DBAs and helping other new members on the team to integrate the project.

Responsible for Installation, Configuration and Administration of SQL Server 2008, 2012, 2014, 2016 and 2017

Upgraded and Migrated SQL Server from version 2012 to 2014 and 2016

Created and re-evaluated indexes and made modifications for better performance.

Table Partitioning for existing and new application databases.

Developed and implemented maintenance plans in both DEV and PROD environments

Backups and Restore of different databases on SQL Server instance.

Creating databases and logins with permissions in SQL Server as per requested.

Performance tuning, trouble shooting and monitoring using Performance Dashboard reports, Database Tuning Advisor, SQL Profiler, Server Side Trace, Dynamic Management views

Created new ASM disk groups on new devices for RAC and non RAC DBs.

Using Flash-Back Recovery, ASM & Automatic Database Diagnostic Manager

Installed ASM file system and migrated databases from NON-ASM to ASM.

Proactive monitoring & performance tuning of dbs. Developed code for efficient Prod deployment

Identity and Access Management to environments and databases. Created and managed user profiles, passwords, granted and revoked user privileges and roles to different objects.

Riley Technologies - Mooresville, NC

Database Administrator 08/2014 to 05/2017

Supporting multiple databases for production, development, test and staging purposes on RHEL, Sun Solaris and Windows environments.

Applying upgrade patch, maintenance and interim (Opatch) patches on all the databases.

Refreshing Dev and Test instances with data from Production on a regular basis.

Thorough knowledge in setting up infrastructure for databases in huge datacenters.

Responsible for Installation, Configuration and Administration of SQL Server 2008, 2012.

Upgraded and Migrated SQL Server from version 2012 to 2014 and 2016

Created and re-evaluated indexes and made modifications for better performance.

Table Partitioning for existing and new application databases.

Developed and implemented maintenance plans in both DEV and PROD environments

Backups and Restore of different databases on SQL Server instance.

Creating databases and logins with permissions in SQL Server as per requested.

Performance tuning, trouble shooting and monitoring using Performance Dashboard reports, Database Tuning Advisor, SQL Profiler, Server Side Trace, Dynamic Management views

Installed Oracle 11g on Linux platform using ASM.

Worked on Configuring OEM 12c console and installed OEM12c agents on different platforms using push method from console and also using silent method.

Worked on Oracle GoldenGate installation, configuration and troubleshooting.

RMAN point in time recovery and Instance recovery done on 11g.

Moving and storing of backups on Amazon Web Service (AWS) S3 cloud.

Developed compliance reports and performed auditing at higher levels.

Scheduling bash jobs like schema stats, exports, table space usage report using crontab.

Applied database patches using Opatch utility for RAC and Non RAC databases & building Clone instances for Development and Test teams.

Handled all DBA daily activities and excellent experience with SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity .

Installed and configured Oracle OEM 12C on test environments. Used OEM extensively to monitor the general health and troubleshoot/diagnose problems in the environment both on server, database level and also most importantly at the Sql level to identify and subpar Sql queries. Configuring custom metrics, monitoring templates and alerts set up based on individual dba preferences and also tailored to application requirements.

Monitoring the CPU, memory usage, I/O contention on servers

Experience in UNIX/SHELL scripting.

Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future implementation on 10g production.

Applied PSU Patches (11.2.0.3, 11.2.0.4) as a part of maintenance activity.

Implemented and managed optimum physical database design (table spaces, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture

Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.

Extensive experience in RMAN recovery testing, RAC and standalone database

Experience in setting up Oracle ASM storage for Oracle RAC databases.

Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.

Responsible for the smooth functioning of all ecommerce activities of the organization.

Monitored data transfer between the Database servers using Data Stage, Oracle Streams/CDC

Successfully implemented Backup & Recovery using RMAN with hot and Cold backups.

Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.

Performed SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.

Walgreen Company - Deerfield, IL

Database Administrator 03/2011 to 08/2014

Installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.

Monitored different DBs and application servers with Oracle Enterprise Manager 10g Grid Control.

Used TOAD for database management.

Database refreshes using expdp, Impdp, RMAN Duplicate and cloning.

Experienced in HOT and COLD database cloning for backups.

Database monitoring/maintenance and performance tuning using OEM

Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).

Documented the Standard Operating Procedures for the team.

Applying upgrade patch, maintenance and interim (Opatch) patches on all the databases.

Implemented Flashback technology of the Oracle 11g, 10g along with Recycle bin for a faster recovery of the databases and database objects.

Performed full & incremental backup using RMAN and implemented recovery strategies.

Refreshed/cloned databases using RMAN utility.

Performed Database upgrade from Oracle 10g (10.2.0.5) to Oracle 11g (11.1.0.7) RAC database.

Successful in applying RDBMS patches including security patches and bug fixes

Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.

Responsible for Installation, Configuration and Administration of SQL Server 2008, 2012.

Upgraded and Migrated SQL Server from version 2012 to 2014 and 2016

Table Partitioning for existing and new application databases.

Developed and implemented maintenance plans in both DEV and PROD environments

Backups and Restore of different databases on SQL Server instance.

Creating databases and logins with permissions in SQL Server as per requested.

Performance tuning, trouble shooting and monitoring using Performance Dashboard reports, Database Tuning Advisor, SQL Profiler, Server Side Trace, Dynamic Management views

Contact this candidate