Mariette Tchinkou

Sr. Oracle Database Administrator

AWS Certified

Phone: 508-***-**** Email: adjod6@r.postjobfree.com

LinkedIn – Mariette Tchinkou

PROFESSIONAL SUMMARY

Experienced IT professional with skills including but not limited to capturing applications’ functional and non-function requirements, mapping requirements to a set of AWS services- data, compute, storage, management, network, microservices and security, creating solution proposals in line with an organization’s goals around performance, scalability, elasticity, security, management and monitoring and creating these solutions while democratizing advanced technologies. An accomplished and seasoned professional Senior Oracle Database Administrator (DBA) Worked on large-scale database environments performing various DBA services across a multitude of platforms such as LINUX/UNIX, Windows, and Solaris. She is also proficient in various technologies such as Oracle 10g, 11g, 12c, SQL loader, MySQL, and MS SQL server. A highly motivated individual with strong leadership and interpersonal skills, who can be trusted with highly sensitive/confidential documentation and projects. An enthusiastic, proactive team player who is fast at picking up new technology with great attention to detail. A perfect Bilingual in both French and English and Possesses excellent written and verbal communication with the ability to articulate a variety of concepts to technical and non-technical audiences.

AREAS OF EXPERTISE INCLUDE

Installation, configuration, capacity planning

Performance Monitoring & Tuning

Backup & Recovery, Upgrades & Migration

Database Security & Patching

Oracle ASM & Grid control

Oracle Data guard

Oracle Golden Gate

Bash/Unix Shell scripting & Automation

TECHNICAL SKILLS AND TOOLS

Installation, configuration and update of Oracle 11g 12c and 18c using OUI, DBCA, DBUA,

Monitoring and performance tuning using OEM Console, Toad, SQL Developer, Grid Control, TKProf, Explain Plan, Statspack/AWR, ADRCI, ADDM, DRA, Dbms_monitor.

Work with various operating systems like MS Windows Servers(2008, 20012), UNIX (Solaris 8/9/10), LINUX (Red Hat)

ETL tools: SQL*Loader, Golden gate

Oracle Enterprise Manager

Cloud Orchestration / Automation: AWS CloudFormation, AWS Lambda, AWS Systems Manager, AWS SSM Parameter Store, Ansible, Docker, Jenkins, ECS, EKS, Terraform

Governance and Compliance: AWS Config Rules, AWS Organization, AWS Control Tower, AWS Trusted Advisor, AWS Well Architected Tool, AWS Budgets, AWS License Manager

Programming Languages: Bash, JSON, YML, Python

Application Delivery: Jira, Confluence, Jenkins, Bitbucket, AWS Code Pipeline, AWS Code Commit, AWS Code Build, AWS Code Deploy

Data Protection: AWS Certificate Manager, AWS KMS, Snapshot Lifecyle Manager, AWS Cloud HSM

MS SQL Server Management Studio

Backup & Recovery using RMAN

SQL, PL/SQL, UNIX Shell Scripting

Oracle ASM (clusters) and RAC configuration and administration

Oracle Golden Gate (Data Replication)

Database security

Oracle Data Guard installation/administration for High availability and Disaster Recovery (DR)

Database migration using Exp/Imp/Datapump, and SQL Loader

Monitoring and Event Management: AWS CloudWatch (Events and Logs), AWS SNS, AWS S3

Identity and Access Management: AWS Organization, AWS IAM, AWS AD Connector, Active Directory, AWS Workspaces, AWS Secrets Manager, etc

AWS Security: AWS Security Hub, AWS Guard Duty, AWS Shield, AWS Firewall Manager, AWS Inspector

Self Service: Service Catalog

Network: VPC, VGW, TGW, CGW, IGW, NGW

Image and Patch: AWS SSM Patch Manager, AWS Golden AMI Pipeline

PROFESSIONAL EXPERIENCE

MARYLAND DEPARTMENT OF HEALTH AUGUST 2018 – PRESENT

Oracle/AWS Database Administrator

Migrated high availability webservers and databases to AWS EC2 and RDS with minimum or no downtime.

Life cycle configuration for data to live and cycle within buckets in accordance with how often it can be accessed thereby minimizing cost.

VPC build with Private and Public Subnet couple with VPNs setup back to on premise datacenter and corporate offices.

VPC peering with other accounts allowing access and routing to service and users of separate account to communicate.

Prepare Standard Operating Procedures (SOPs), work instructions, and related supporting documents based on Quality Systems Unit guidelines

Architected serverless solutions using AWS Lambda and Amazon API Gateway in event-driven patterns to power scalable and secure serverless applications.

Created an event-driven proof of concept serverless architecture that uses managed services that are appropriate for our expected data flow and scaling requirements.

Defined methods for failure management, performance testing, and application auditing within our serverless architecture and deployed updates to the serverless application without downtime.

Leveraged AWS management tools to programmatically provision, monitor, and automate all the components of our cloud environments.

Implemented AWS Systems Manager management service capabilities to automatically collect software inventory, apply OS patches, and automate administration tasks and complex workflows across our environments.

Leveraged different design principles for security in the cloud and implemented various AWS services to improve our security posture for Authentication, Authorization, Monitoring, Auditing, Encryption and Data path security.

Implemented containers on AWS using ECS and complementary services, including Amazon Elastic Container Registry (ECR).

Implemented and managed Ansible Tower to scale automation and handle complex deployments.

Installed and configured software for Oracle 10g, 11g, 12c on both Windows and UNIX platforms using Oracle OFA. Also Installed, Administered and Maintained SQL Server Instances 2008 and 2012

Lead database migration project from 10g to 11g and database upgrade from 11g to 12c using the Oracle Data pump and DBUA respectively.

Daily incremental backup and weekly full backup of databases using RMAN

Rewrote and implemented a backup strategy following company SLA; execution of backup schedule for both physical and logical backups using RMAN and DATAPUMP utilities, respectively. I also used block change tracking (BCT) which reduced incremental level 1 backup time from 4hrs down to 25mins.

Supported daily administration, monitoring, tuning, and troubleshooting on single instance on UNIX/Linux, Windows server 2008 and 20012 (Database sizes range 100GB to 39TB)

Monitored AWR, ADDM, ASH, Alert log, dynamic performance views, DBMS_STATS, Trace Files, and System Event Logs for unusual events and took appropriate action according to company policies of incident reports.

Implement table and index partitioning to Minimize DB_time, increase disk load balancing, improve query speed and enable faster parallel query.

Capacity planning to meet the demands of the dynamic aspects of storage and memory for the databases

Deployed Database security policy and installation, using passwords, privileges and user profiles, Used Oracle Transparent Data Encryption to encrypt columns, tables and Tablespaces, I also implemented the “triple A” (AAA) and database auditing policies as well as data redaction

Cloned databases using RMAN and DATAPUMP utilities for all database sizes

Installed and administered Oracle Physical Standby Database for single and multiple instances to achieve high availability and DR solution (DATA GUARD)

Applied Oracle's quarterly Critical Patch Update (CPU/ PSU application) using Opatch utility to install, test, and deploy patches to all database instances

Performed database Refreshes from production environments.

Performed PL/SQL errors fixes and modified the applications using PL/SQL

Part of the on-call production support team for 24/7 on-call production support

managing the development and performance of SQL server databases for web applications

conducts troubleshooting and bug fixing on SQL server databases and applications, resolving issues without excessive downtime or data loss.

ANALYTICA WASHINGTON DC JULY 2016 – MARCH 2018

Database Administrator

Created databases from Entity Relational Diagrams (ERD) in Forward Engineering using the Oracle SQL Developer to OFA Institution and finally to DB launch.

Performing Day-to-Day DBA tasks: performance tuning, system security, database installation configuration, patching, technical database support in 24X7 environment to ensure system performance and stability.

Loading data into database tables using SQL Loader.

Frequently monitor emails regarding any database issues.

System Development Life Cycle (SDLC) methodology for designing analysis, development and implementation.

Designed and implemented the ETL utilizing PL/SQL.

Used range, hash and composite table partitioning which greatly decreased the DB_time and SQL Execution time. Also performed instance tuning by changing init.ora parameters and managed region parameters such as shared_pool_size and db_cache_size with the use of AMM and ASMM.

Managed database security by creating, assigning appropriate roles and privileges to users depending on the user activity, auditing, and performing other security related tasks including Transparent Data Encryption.

Installed and configured the Oracle Golden Gate software on Unix/Linux platform for both Unidirectional and Bidirectional replication

Configure and manage ASM instances on Oracle 11g.

Worked in a cross functional team that oversaw the Oracle RAC installation and configuration for Linux environments.

providing proactive database administration and production environment support for multiple Microsoft SQL Server database environments.

Experience administering complex (enterprise-level) SQL Server environments

Expert in working with PL/SQL including Procedures, Functions, Cursors and Triggers.

Created and managed pluggable databases in the multitenant container database of the Oracle 12c architecture

Experience migrating database objects from development through test and into production environments

Configure and manage Cloud Watch alarms to monitor resources in Memory, and CPU utilization.

Capacity planning (supported 3 tier architecture, planning of tables, indexes, table spaces and databases) to allow for growth potential and analyze data growth trends for capacity and resources.

Developed load procedures using SQL and other procedures to keep the Database current, Presented to management on a weekly basis the progress and issues regarding the data.

HARBORONE BANK BOSTON JUNE 2010 – SEPT 2016

Oracle Database Administrator

Deployed Database security policy and installation, using passwords, privileges and user profiles, Used Oracle Transparent Data Encryption to encrypt columns, tables and Tablespaces, I also implemented the “triple A” (AAA) and database auditing policies as well as data redaction

Cloned databases using RMAN and DATAPUMP utilities for all database sizes

Capacity planning (supported 3 tier architecture, planning of tables, indexes, tablespaces and databases) to allow for growth potential and analyze data growth trends for capacity and resources.

Clone, refresh, backup Oracle databases using RMAN, Data Pump. Maintaining, preparing and following detailed technical documentation.

Creating new banner users and granting access on banner forms/pages, adding users to different banner classes.

Monitored nightly jobs scheduled on Active Batch by checking the operation views and job queues.

Provide support of the Oracle database and related tools for multiple clients

Review and install updates and patches for the Banner ERP and related 3rd party products

Conduct database tuning, security, backups, and optimization of the database for the Banner ERP

Provide troubleshooting assistance with issues related to user logins and single sign on for Banner9

Provide senior technical leadership to assist clients with complex technical planning and task management for clients implementing all the Ellucian Banner products

Installed and administered Oracle Physical Standby Database for single and multiple instances to achieve high availability and DR solution (DATA GUARD)

Contact this candidate