Information Security Data

Tejas Thakur

+1-862-***-**** **************@*****.***

https://www.linkedin.com/in/tejasthakur123/ https://tinyurl.com/tejasthakur https://github.com/tejasthakur123/

Database Administrator:

Production Database Administrator having work experience of almost six years with a track record of incorporating user and business requirements into cost-effective, secure and user-friendly solutions known for scalability and durability. Currently pursuing master’s degree in Rutgers University and with Concentration of Information Technology program.

Experience design and developing a server-side database management system (DBMS) on multiple platforms. Maintain security infrastructure and best practices with High Availability and optimum resource utilization/Tuning.

Proven success in designing high-integrity relational/dimensional databases and business solutions which are supporting critical business areas.

Certification:

Oracle Certified Professional: OCP 12c

Oracle Database 12c SQL Fundamentals Oracle Database 12c Administration Oracle Database 12c Advance Administration

MongoDB: M102.

AWS Certified Solution Architect:

AWS Certified Solutions Architect – Associate (SSA)

ITIL: ITIL v3 Foundation

Python: Microsoft: DEV274x Introduction to Python: Fundamentals

Skills:

Oracle10g, 11g, 12c, MS SQL Server, MySQL, Oracle RAC, POC, Transparent Data Encryption, Health Checks, Goldengate, Microsoft Projects PL/SQL, Performance Tuning And Optimization, Amazon Web Services, AWR, SQL Trace, TKPROF,ASH,ADDM, ASM, RMAN, Data Guard, Standby Database, Goldengate, OEM,TOAD, Audit Vault,,Shell Scripting, Bash, Python, PL SQL, Cloud Control, Grid Control, SQLPlus,Database modeling, Performance Baseline, ODA, MongoDB, SDLC, Ansible,Chef, MS Office, RHEL, AIX, Database Design, Database creation, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Business Solutions, Data Warehousing & Integration, Object & Dimensional Modeling, Scripting, Coding & Documentation, Risk Management, Information Security, Network Configuration, DevOps, On-shore and off-shore supporting teams experience

Professional Experience:

TCS ltd., IT Analyst, Database Administrator Nov 2014 – Jul 2017

Projects –

1)Liquid Telecom.

2)BIAL.

3)Gulftainer Ltd.

4)Petrofac International.

5)Vodafone mPesa.

Support for various projects and key resource in the field of Oracle, MS SQL Server & related Technologies. Working Design, Develop, Implement, Configure and maintain as well as ticketing system to solve /troubleshooting day to day activities and system enhancement providing support to the various teams and seamless business continuity with windows and Linux environments.

Worked in the Team/Team Lead and individual resource to deliver secure, robust and scalable backend infra Solutions that helped improve efficiency, information security, data integrity, and customer satisfaction.

Worked on Goldengate replication from production to reporting system to generate a report on schema level and table level.

Familiar with UNIX platform system administration, Automation of various tasks with the help of python and bash scripting.

Worked extensively on OEM infrastructure, SSMS, RAC, Grid control management, Golden gate replication, RMAN, Data Guard.

Experience in DBA activities like database lifecycle management, creation, upgrade, migration, patching, cloning, backup & recovery, alert monitoring, space & user management, performance tuning, and optimization, database corruption.

Experience with different( RMAN / Logical) backup and recovery scenario. Backup Policy for better business continuity.

Responsible for Day to day activities as well as projects related to the organization. And forecasting like capacity planning etc.

Optimizing the redo transport for high availability solutions by tuning advance features of DBMS lead to save $180K/Year.

Configuration and deployment of security patches and update with Ansible Playbook on Linux server.

Performance tuning for the database as well as SQL queries. Help to reduce report generation time by 120min.

End to end execution of Database upgrade for 23 business application counted to 140+ databases. Delivered in a tight timeline.

Strong experience with Oracle, RAC, DataGuard, Installation, Configuration, Patching, Upgrade, Maintenance in production.

Implemented the archival & purge policy for tables which save 400GB/ month. Optimize storage space by 10-12% per month.

Adaptive to change, Interpersonal, problem-solving and analytical skills, interpersonal skills, Team Player, Excellent verbal and written communication skills, Strategic thinker, self-managed, leadership Qualities. Believe in innovation and enthusiastic.

Clover Infotech Ltd., Technical Associate, Database Administrator Jan 2012 - Nov 2014

Project –

1)RBL Bank

Responsible for the bank’s core banking database and other supporting applications. Working on a ticketing system to solve /troubleshooting the system blocks. And system enhancement providing support to the various teams and seamless business continuity.

Table partition and remove fragmentation to improve performance by almost 20% for report generation & storage space.

Majorly involved in Day to Day BAU activities and provided supports to an ongoing project for banking environments.

Automation of various tasks via creating a dynamic bat and shell file for index rebuild and gather stats on the production database. Save almost 30hr/Month.

Design and implemented backup policy and DR solutions, Upgradation, Security Patching, Backup & Restoration, DR drills. Result in better business continuity.

Academic Projects and Paper, Rutgers University Sept 2017- Dec 2018

Information Security

Wrote Research Paper “Intrusion Detection with the help of Artificial Intelligence” and proposed a solution. With the help of Artificial Intelligence help to detect intrusion in system.

Data Privacy

Worked on the research paper for “ Data Privacy in healthcare Domain” where I try to analze varuious technique like differencial privacy, generalization etc

Introduction To Data Science

Worked on project “Credit Card Fraud Detection”. We use the dataset from europian cardholder with almost 300K entries. Try to analyse the potention Fraud card transaction.

Business Data Management

Designed database for Student Attendance Portal using MySQL performs ETL activities on the database. Created Graphic user interface (GUI) using HTML, JavaScript and CSS.

Contact this candidate