Jestin Thomas Maliakel

** ******** ***, ****** ******, NY, 10302

ad4mzq@r.postjobfree.com

646-***-****

Summary

8+ years DBA experience and in-depth knowledge of Microsoft SQL Server 2008/2012/2016 and utilities

Proficiency in relational database management System (RDBMS) in MSSQL server 2008, 2008R2, 2012, 2014 and 2016.

Experience in installation of MSSQL Server and configuring backups, DB Mail, and user permissions.

Experience in configuring and troubleshooting Oracle 19c and MySQL database servers.

Experience in setting up SQL Server cluster and Log shipping.

Experience in implementing Secure Sockets Layer (SSL) Certificate for SQL Server Cluster and Standalone.

Experience in setting up Transparent Data Encryption (TDE).

Experience in setting up Column level Encryption.

Experience in creating and maintaining database objects, functions, triggers, stored procedures in MSSQL and MySQL servers.

Experience on patching, upgrading and Migrating SQL Server Software to new versions.

Experience in capacity planning, implementing and SQL Database migration.

Experience in setting up Management Data Warehouse (MDW) to collect data about the server.

Experience setting up SQL Server jobs to monitor disk space, CPU activity and Index fragmentation.

Experience with SSIS, creating and deploying SSIS packages/projects.

Excellent knowledge and Experience in backup/restore operations, database design, T-SQL (DDL, DML and DCL).

Hands on Experience on Security management in MSSQL, Oracle 19c, & MySQL: System and object privileges, creating and modifying roles.

Knowledge in database technologies (MS SQL Server Cluster design, Always On Availability Group, Replication).

Proficiency in varies server operating system and applications, installation, configuration and troubleshooting.

Ability to learn quickly retains knowledge, apply effective interpersonal skills, and perform effectively under time pressure.

Excellent listening and communication skills.

Education

Masters in Information Systems Management (Database Administration) (6/2014)

KELLER GRADUATE SCHOOL OF MANAGEMENT, NEW YORK, NY

Bachelors of Science in Biology (6/2012)

COLLEGE OF STATEN ISLAND, STATEN ISLAND, NY

Clearance

Active Secret clearance

Certifications

MTA: 98-364 - Database Administration Fundamentals

Technical Skills

Operating Systems: Microsoft Windows 7,8,10, Ubuntu and Centos.

Software: MS SQL server 2008, 20008R2,2012, 2014, MySQL 5.1 – 5.6, SSMS, SSIS, SSRS, Oracle 19c, MySQL Workbench, Microsoft Office Word, Excel, Outlook, PowerPoint, Access, Project, Visio, Enterprise MacAfee, VMware VCenter, Apache Hadoop, Hive, Pig, Flume and Sqoop.

Database Migration: SQL Server to SQL Server, MySQL Server to MySQL Server

ETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data, Bulk Copy Program (BCP)

Data Modeling Tools: Visio, SSDD (SQL Server Database Diagram), Oracle data modeller.

Languages: Linux commands, HDFS shell commands, T-SQL, PowerShell scripting.

Employment History

ASRC Federal Holdings (NASA Ames Research Center), San Jose, CA

Database Administrator April 2017 – present

Responsibilities:

Install, Configure, and Maintain Databases in (MS SQL server 2008, 20008R2,2012, 2014,2016), Oracle 19c and MySQL 5.0/5.1/5.5

Perform Database Backup/Dumps, Database Restore on MSSQL, Oracle 19c and MySQL servers.

Monitor Server Activity, Error Log, space usage and solving problem as needed

Monitor, troubleshoot, resolve and report on data integrity problems in Databases, nightly backups, SQL jobs, and log shipping.

Setup Maintenance plans for backups, Rebuilding or reorganizing indexes, check server health, alert, notifications

Perform Oracle 19c database refresh using expdp/impdp data pump

Setup SQL Server Agent Jobs and Schedules for automated and timely execution of Daily, Weekly and Monthly processes

Implementation of Permission, Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Maintained server and database security including database encryption (TDE).

Implement SSL certificate for SQL server Cluster and Standalone.

Maintain databases and database instances currently hosted at Amazon AWS services on EC2 instances.

Copy files from AWS EC2 instances to S3 bucket.

Write SQL/T-SQL queries, Stored-Procedures, Views, functions, and Triggers

Develop and maintain database structures, database objects, and ETL processes.

Create and implement SSIS package for the automation of ETL process.

Responsible for setting up SQL Server jobs to monitor disk space, CPU activity and Index fragmentation.

Monitor automated jobs using UNIX based scripts (e.g. shell) for data processing and data backups.

Work closely with QA and Development Teams in reporting and fixing database related bugs in software.

Assist our development team with writing effective T-SQL stored procedures and views.

Experience in administering Linux based systems.

Provide technical support and guidance to resolve issues with exceptional customer service.

Apply critical thinking to complex problems where analysis of situations and data requires an evaluation of numerous factors and collaboration with more senior DBAs

Analyzes and diagnoses problems reported to the Database queue in help desk ticketing system.

Celerant Technology corp

Software support Technician, April 2015 – April 2017

Responsibilities:

Provide technical support and guidance to resolve issues with exceptional customer service

Investigate, Troubleshoot and resolve all POS software, Database and Application server related problems

Work closely with QA and Development Teams in fixing reported Software Bugs

Manage and Maintain Database (MS SQL server 2005, 2008, 20008R2,2012, 2014) and Application server

Manage and maintain scheduled SQL Server Agent jobs in Production Database server and Data warehouse Database

Use SQL to create reports and manipulate data.

Resolve communication problem among POS Frontend, Application server and Database

Troubleshoot Application Port problems

Perform Database Backup, Database Restore if necessary

Provide and control Database access permissions and privileges to users

Configure and install POS software based on client’s requirement

Troubleshoot and solve data integrity problems in Database

Create Reports based on Client's requirement

Provide assistance with recovery of lost or corrupted data

Provide on call support remotely

Contact this candidate