Uploaded File
Dinesh
dino4u@gmail.com
201-210-9079
United States Air Force Acad, CO 80840
Oracle DBA | MongoDB DBA | Hadoop Administrator
15 years experience W2
0
Recommendations
Average rating
14
Profile views
Summary

  • Database & Hadoop Administrator with extensive experience designing, installing, upgrading, migrating and supporting next-generation HA database solutions.
  • Proficient in an assortment of technologies including Oracle (Database 10g/11gR2/12c, RAC, Dataguard, OEM, RMAN, TDE, SQL Developer), MongoDB (Replica set, Ops Manager, Compass), Cloudera Hadoop (HDFS, YARN, Hive, HBase, Sqoop, Flume, Kafka, Spark, Hue etc), MS SQL Server, Foglight, Shell Scripting, Rundeck, Toad, Rally, Jira, Jenkins, git, Bitbucket, Ganglia, WinCVS, Crucible, Control-M, Visio, IIS, HTTP Server, AWS (EC2, S3, RDS), Windows and Unix.
  • Excellent analytical, problem solving, communication and interpersonal skills with ability to interact with individuals at all levels and can work as a part of a team as well as independently.

Experience
Sr. Database / Hadoop Administrator
Aug 2019 - present
United States Air Force Acad, CO
Hadoop
Remove Skill
Lead Database / Hadoop Administrator, Barclaycard US
Dec 2014 - Jul 2019
  • Installation, Upgrade, Migration, Administration & Maintenance of Oracle Database/RAC/Dataguard, Oracle Enterprise Manager, MongoDB Replica set, Ops Manager and Cloudera Hadoop clusters.
  • Drive releases/changes/severity incidents involving coordination with business aligned teams, stake holders and various infrastructure / DevOps teams.
  • Implement ILM & TDE for various databases after confirming the retention targets & columns with Business teams.
  • Tested and implemented VNCR solution in all oracle database to remediate critical vulnerability called “TNS Listener Poison Attack”.
  • Created a framework using sql queries to report performance metrics like attainment, capacity, say-do, backlog etc from Rally database for all verticals in line with organization goals.
  • Created online dashboard for all databases using asp.net, sql & IIS; reporting real time status and performance metrics.
  • Was involved in creating Rundeck based workflow for User Management (create, unlock and reset account) and another for database patching (node / cluster level apply).
  • Created TTL indexes in certain MongoDB collection to automatically remove documents from a collection after a certain amount of time. Setup MongoDB backup’s and monitor the replica set using Ops Manager.
  • Responsible for troubleshooting application jobs errors on hadoop and take corrective actions to ensure job SLA’s are met. Work with application teams to carry out capacity planning.
  • Worked with scrum teams to help create migration process for new & legacy systems to the AWS cloud with approved set of AWS components.
AWS Database Backups Hadoop Oracle SQL MongoDB Rally Scrum ASP.NET
Remove Skill
Lead Oracle Database Administrator, Barclaycard UK
Sep 2009 - Nov 2014
  • Managed a team of engineers working on various Digital Portfolio business critical projects based on mobile solutions, anti money laundering, click to chat etc.
  • Installation, Upgrade, Migration, Administration & Maintenance of Oracle Database, Real Application clusters & Dataguard environments.
  • Drive changes & severity incidents involving coordination with business aligned teams, stake holders and various infrastructure teams.
  • As part of AML, PINGIT & BMB flagship project, helped design and setup the database environment, review db changes, and provided advice & guidance to the application teams on db objects & queries. This was well appreciated and received quarterly star award.
  • Carried out database performance analysis / tuning, capacity planning & troubleshooting task and helped the application team with query tuning and database changes / code reviews.
  • Implement Information Lifecycle Management (ILM) & Transparent Data Encryption (TDE) for various databases after confirming the retention targets & columns with Business teams.
  • Setup DR environments and carried out periodic tests using switcher or snapshot standby or flashback restore point depending on environments.
  • Was single point of contact for all process related queries and headed the documentation initiative.
DBA Oracle Database Maintenance
Remove Skill
Sr. Oracle Database Administrator
Oct 2006 - Sep 2009
  • Automated daily monitoring using shell script/SQL and managed to bring down the time spend on this activity from 2-3 hours to 30 minutes.
  • Installation, Upgrade, Migration, Administration & Maintenance of Oracle Database 9i/10g/11gR2 as per the required organization standards along with configuring standby databases.
  • Provided support to application teams by resolving db issues, reviewing codes, implement db changes and query tuning. Also worked with Oracle metalink SR to resolve critical db issues when required.
  • Recovered production databases after server crash and corruptions using RMAN and hot backups.
  • Implemented RMAN backup, Datapump export/import, Database Auditing, BMC Patrol KM module, Control-M for all the databases.
Database Backups DBA Oracle BMC Control-M
Remove Skill
Application Support / DBA
Oct 2005 - Oct 2006
  • Developed a ASP module in document management Project Work Room (PWR) application, which helped end user to implement changes from a single screen as compared to four different screens earlier.
  • Restored DKHelpdesk tool after a server crash, which involved setting up database, application server and application on another server. DKHelpdesk was the most critical application for global Helpdesk support as it ensured 24X7 support to all associates across the globe.
  • Provide level II & III support for various internal application which sometimes involved updating and writing new stored procedures in MS SQL Server depending on business rules and requirements.
  • Created new databases in MS SQL Server for internal applications, monitored all application jobs, imported/exported data using DTS and backup & restored databases.
  • User Management activities like creating/reseting/unlock account and granting/revoking permissions to/from the accounts in both Oracle & MS SQL servers. Steamlined the access across databases by setting up standard roles and profiles.
Database Backups DBA Oracle SQL Server Oracle 7 SQL Stored Procedure
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Electrical
Government Polytecnic Pune, 1998 - 2000
Record has not been verified.
Computer
Indira Gandhi National Open University
Record has not been verified.
Skills
Oracle
2019
14
Database Backups
2019
9
DBA
2014
9
Hadoop
2021
6
SQL
2019
6
ASP.NET
2019
5
AWS
2019
5
Database Maintenance
2014
5
MongoDB
2019
5
Rally
2019
5
Scrum
2019
5
BMC Control-M
2009
3
Oracle 7
2006
1
SQL Server
2006
1
Stored Procedure
2006
1
AIX
0
1
AWS EC2
0
1
AWS S3
0
1
Data Migration
0
1
Data Warehousing
0
1
Database Design
0
1
Dataguard
0
1
Disaster Recovery
0
1
ETL
0
1
Flume
0
1
HA
0
1
Hadoop Admin
0
1
Hbase
0
1
Hive
0
1
ITIL
0
1
Jenkins
0
1
Kafka
0
1
MariaDB
0
1
Microsoft SMS Server
0
1
Oracle RAC
0
1
Patch Management
0
1
Performance Tuning
0
1
PL/SQL
0
1
Problem Solving
0
1
RMAN
0
1
Scripting
0
1
Shell Scripts
0
1
Solaris
0
1
Solutions Architecture
0
1
Spark
0
1
SQL Developer
0
1
Sqoop
0
1
System Administration
0
1
UNIX
0
1
Awards
Best Engineer Award , 0
Global IT Award , 0
Quarterly Start Award, 0
Spot Award, 0
Spot Award, 0