Resume

Sign in

Oracle Database Administrator

Location:
Ann Arbor, Michigan, United States
Salary:
100000
Posted:
May 17, 2018

Contact this candidate

OMKAR SUNKERSETT

(Oracle PartnerNetwork Certified Specialist)

• Phone : +1 (734) ***-**** • Email : ac5h1q@r.postjobfree.com • LinkedIn : https://www.linkedin.com/in/os-db EDUCATION

University of Michigan, School of Information, Ann Arbor 04/2018 Master of Science – Information Analysis & Retrieval GPA: 3.91 / 4.00

• Courses: Python Programming, Statistics in R, Data Manipulation, Information Visualization, Natural Language Processing, Data Mining, Network Analysis, Information Retrieval, Predictive Analytics using R, Project Management. University of Mumbai, Fr. Conceicao Rodrigues College of Engineering, India 07/2012 Bachelor of Engineering – Information Technology GPA: 3.67 / 4.00 CERTIFICATIONS

Oracle – Oracle Database Cloud Service Implementation Specialist (OCS) 04/2017 Oracle – Oracle Certified Exadata Database Machine Implementation Specialist (OCS) 06/2015 Oracle – Oracle Certified Professional, MySQL 5.6 Database Administrator (OCP) 05/2015 Oracle – Oracle Certified Database 12c Administrator Professional (OCP) 05/2015 Oracle – Oracle Certified Database 11g Administrator Professional (OCP) 09/2014 Oracle – Oracle Certified Database 10g Administrator Professional (OCP) 07/2013 Oracle – Oracle Certified Database 10g Administrator Associate (OCA) 05/2013 Oracle – Oracle Certified Database SQL Expert (OCE) 02/2013 IBM – IBM Certified DB2 9.0 Academic Associate 04/2011 PROFESSIONAL EXPERIENCE

University of Michigan School of Information Ann Arbor, MI Programmer – Java and Python Development 02/2018 – 04/2018

• Coded a Time Series module using object-oriented Java & Python to track the attendance of students in online courses.

• Validated the Java and Python code by writing test cases; Fixed and updated the Java documentation for the project. University of Chicago Argonne, LLC Lemont, IL

Research Aide – Data Engineering & Analytics Intern 06/2017 – 09/2017

• Created Python scripts to fetch 100+GB of energy-price CSV data from internet portals for 4 U.S. electricity markets.

• Architected a MySQL 5.7 database (size: 125M+ records); Cleaned and transformed the CSV data for InnoDB storage.

• Achieved 90% space reduction using row compression; Improved query performance by 85% using B-Tree Indexes.

• Developed R scripts to generate price reports; Devised visualizations using Tableau; Documented the solution. University of Michigan School of Public Health Ann Arbor, MI Research Assistant – Database Manager 11/2016 – 01/2018

• Redesigned a relational database in Microsoft Access 2016 using the principles of data normalization.

• Programmed in Python to process and store semi-structured epidemiological data in the new database.

• Analyzed the healthcare data using advanced SQL queries to provide valuable insights to the research team.

• Mentored 2 undergraduate research assistants on the project throughout the course of the academic year. Capgemini Mumbai, India

Consultant – Level 3 Oracle Database Administrator 08/2012 – 02/2016

• Provided the highest technical support to 18 critical clients across 10 countries and 15 industries; Operated the world’s most sustainable data center remotely to maintain mission critical databases in production with 97% service availability.

• Received two consecutive promotions in a course of two years for outstanding work and contribution to the project.

• Awarded a ‘Client Recognition Award’ by the Account Director for exceptional client delivery and excellent commitment to a database upgrade project from Oracle 10gR2 t0 11gR2 for an esteemed client based in the UK.

• Participated in 3,000+ management and technical bridges to troubleshoot and fix 1,200+ critical production issues for various customers across USA, UK, Ireland, Poland, Romania, France, Germany, Sweden, Vietnam, and India.

• Resolved 5,000+ production incidents around the clock by brainstorming with I.T. specialists with 98% SLA compliance; Planned & executed 600+ critical changes to the data center infrastructure for Fortune-500 clients from a wide range of industries with 99% successful outcomes; Interacted with My Oracle Support on 250+ critical severity service requests.

• Performed build, patching, upgrade, performance tuning and migration activities for over 100 production databases for esteemed customers such as House of Fraser, Corus Group, and Virgin Trains; Attained 100% client satisfaction levels. OMKAR SUNKERSETT

(Oracle PartnerNetwork Certified Specialist)

• Led disaster recovery rehearsals, backup, restore, cloning, and data refresh activities across 8 data centers each year with several clients such as London Borough of Croydon, WHSmith, The Coal Authority and Matalan with 100% success.

• Designed monitoring solutions for 100+ databases in production and participated in 24/7 on-call support, including building a management server for Amazon’s web services platform databases to ensure nearly zero downtime to business.

• Initiated service improvement plans to reduce costs and man-hours by up to 90% by implementing issue catalogs, risk registers, daily & monthly service reviews, shell scripts and problem & change management reviews.

• Persuaded technical teams to close the I.T. Baseline Compliance Security Audit for 5+ major accounts; Identified 50+ threats and vulnerabilities in the databases; Prepared reports with detailed evidences & feasible recommendations; Convinced clients to apply suggestions via change management processes with 100% satisfaction.

• Appointed single point of contact in 3+ large-scale data center transition activities; Interfaced with 3rd parties to skillfully migrate enterprise systems amongst multiple data centers during their transition period without any impact to service.

• Mentored 14+ new recruits on database administration and data center operations management; Managed escalations from Level 1, 1.5, and 2 service tiers to prevent production issues from turning into service management problems.

• Built and monitored 100+ production databases to support mission critical customer-facing applications by liaising with Capgemini’s Global Architect Community; Prepared Root Cause Analysis documents for 10+ business outages.

• Worked as an ad-hoc PMO for a pyramid optimization drive across 12 major infrastructure projects covering around 250 full-time employees; Brainstormed with managers globally to successfully align the right resources to different projects. LEADERSHIP & COMMUNITY INVOLVEMENT

Representative, UMSI 2018 Class Gift Committee, Ann Arbor 03/2018 – 04/2018

• Developed ideas, timeline and communications strategy to solicit philanthropic gifts from 200+ graduating students. Treasurer, U-M School of Information Master’s Association, Ann Arbor 04/2017 – 04/2018

• Officially represented 450+ students; Co-organized multiple school events; Prepared financial reports for the school. Co-Organizer, Project Synergy, Rotary International Dist. 3140, Mumbai, India 06/2015 – 07/2015

• Responsible for sponsorships, procurement and publicity; Conducted drawing competitions for the orphan children. Volunteer, Bafna Charitable Trust, Veetraj Education & Cultural Society, Mumbai 08/2012 – 08/2015

• Taught mathematics, music and computer applications to underprivileged high school children from the rural areas. SKILLS & INTERESTS

• Technical Proficiency:

Proficient: Python, R, SQL, MySQL, Tableau, Java, PHP, HTML, CSS, JavaScript, D3, JQuery, Hadoop, MapReduce. Advanced: Oracle DB Architecture, Recovery Manager, Oracle RACs & ASM, Oracle Data Guard, Enterprise Manager.

• Databases & Frameworks: Oracle 7i/8i/9i/10g/11g/12c, Microsoft SQL Server 2008, MySQL 5.6/5.7, ITIL, ITSM.

• Server Operating Systems: IBM AIX, Oracle Enterprise Linux, Oracle Solaris, HP-UX, Microsoft Windows Server.

• Acclaim: Oracle Credentials – https://www.youracclaim.com/user/omkar-sunkersett

• Blogging: Oracle Technical Blog (16,000+ hits) – http://dba-omkar.blogspot.com

• GitHub: Master’s Papers & Projects – https://github.com/omkar-sunkersett



Contact this candidate