Richa Singh

Toronto, Canada +1-437-***-**** adjcde@r.postjobfree.com www.linkedin.com/in/singh-richa

PROFESSIONAL SUMMARY

Senior Database Administrator (DBA) with 9 years and 4 months of experience in IT industry (6.8 years in Oracle 10g/11g/12c and 2.5 years in Hadoop ecosystem).

Hands-on experience with Oracle 10g/11g/12c Real Application Clusters (RAC) installation and maintenance on Linux, UNIX and SUN Solaris.

Expertise in configuring and managing Data guard, Automatic Storage Management (ASM) instances and various Backup and Recovery techniques.

Hands-on experience in monitoring, optimizing and performance tuning of databases through Oracle Enterprise Manager (OEM) - 12c, installing, patching, upgrading, partitioning and creating databases.

Experience in installation, configuration and management of Hadoop Clusters, MapR, Hortonworks and Cloudera platforms.

Experience in commissioning and decommissioning of the Oracle databases and Hadoop nodes.

Working knowledge of newer versions of Oracle - 18c/ 19c.

Excellent analytical, problem-solving, teamwork, collaboration, verbal and written communication skills.

TECHNICAL SKILLS

Oracle Utilities : Expdp/Impdp, Exp/Imp, RMAN, SQL* Loader

Databases (DBs) : Oracle 10g/11g/12c/18c/19c

DB Management : OEM, Oracle RAC, Data Guard, Golden Gate, ASM, TOAD

Cloud Platforms : AWS, Vodafone Private Cloud, VMWare

Big Data Technologies : MapReduce, HDFS, Cloudera, Hortonworks and Apache Hadoop

Hadoop Ecosystems : Hive, Spark, Sqoop, Yarn, HBase, Pig, ZooKeeper, Flume, Kafka, Hue, Impala and Oozie.

Operating Systems : Unix, Linux, CentOS, Solaris, HP-UX, Windows, Mac

Languages : SQL, PL/SQL, NoSQL, Shell Scripting

PROFESSIONAL EXPERIENCE

Organization

EIT Services India Pvt. Ltd. (DXC Technology) (Bengaluru, India) (Jun 2018 – Aug 2019)

Roles

ITO Svc Delivery Consultant III – Sr. Database Administrator (team size – 20)

Achievement

Successful end to end delivery and management of over 20 application DBs of Deutsche Bank, AG.

Responsibilities

Responsible for supporting 500+ DBs across Dev, QA, UAT and Production environments, OEM configuration and production support.

Providing operational support to the production data base environment including building, scheduling and monitoring the support jobs and resolving data base and user problems.

Coordinating and facilitating Incident/Change Request management.

Disaster Recovery Setup and enabling real time failover, performing node failover and site failover tests.

Leading team of DBAs in setting up a new DR site and providing technical knowhow to DBAs and guiding DBAs to resolve production issues.

Organization

HCL Technologies Ltd. (Bengaluru, India) (Mar 2017 – Jun 2018)

Role

Senior Software Engineer - Sr. Database Administrator (team size – 6)

Achievement

Ensured the successful run of Production and Standby (DR) databases of Intel – McAfee, without any outages during my entire tenure.

Responsibilities

Monitoring and managing 300+ databases.

Installing, configuring and managing Oracle Enterprise Manager (OEM) and checking alert log, trace files.

Implementing and managing Oracle RAC cluster and ASM grid infrastructure.

DB backup and recovery including disaster recovery for all DB infrastructures using Oracle Dataguard.

DB refresh of Dev, QA and UAT environments using production data and configuring DB replication using Oracle Golden Gate.

Setting up of RMAN, Active Dataguard and Partitions, 3PAR migration and round the clock Production DBA support.

Coordinating rolling upgrade patches, migration and upgrading DBs from 10g to 11g and 12c.

Deploying applications and infrastructures as per the build guide.

Representing my team in senior management meetings in order to provide strategic advice to specific projects.

Organization

Synchronoss Technologies India Private Ltd. (Bengaluru, India) (Jun 2014 – Feb 2017)

Role

Database Administrator II (prev. DBA I) (team size – 6)

Achievements

Successful management of over 300 Production DBs for Verizon, AT&T, Vodafone, Frontier, Reliance, British Telecom, Telstra and Vonage.

Responsibilities

Supporting databases across Dev, QA and UAT environments.

Implementing Oracle RAC cluster, ASM DBs on Linux environment and installing, configuring and managing Oracle Enterprise Manager (OEM) and checking alert log, trace files.

Managing tablespaces (creating, adding, resizing, monitoring and allocating) and creation of users and giving necessary privileges, as per the application request, to the colleagues.

Handling the data exchange (import/export) between Hadoop Distributed File System (HDFS) and different web applications and DBs using Flume and Sqoop.

Managing the configuration properties based on volume of the data being processed and the performance of the cluster, connectivity and security of the cluster.

Setting up of Identification, Authentication, and Authorization (Group/Roles).

Monitoring the data streaming between web sources and HDFS and balancing HDFS manually to decrease network utilization and increase job performance.

Setting up of automated processes to analyse the Hadoop log files for predefined errors and send alerts to appropriate groups and to archive/clean the data on the cluster from Name node and Secondary name node.

Providing inputs to development team regarding the efficient utilization of resources like memory and CPU utilization based on the running statistics of Map and Reduce tasks.

Organization

Docendo Consultancy Services Pvt. Ltd. (Bengaluru, India) (May 2010 – Jun 2014)

Roles

Sr. Software Engineer (prev. Software Engineer) (team size - 12)

Achievement

Engaged with Toshiba Pvt. Ltd. regarding its handling of DBs

Responsibilities

Managing the tablespaces, schemas and users (giving necessary privileges as per the application request) of the DB.

Generating the AWR and statspack reports to diagnose the DB performance and security.

Handling day to day alerts and taking backups (RMAN and hot/cold) and setting up of Cronjobs.

Taking schema/table backup through Expdp/Impdp, importing the production dumps into DEV, QA and UAT environments.

Creating, cloning and refreshing DB and installing oracle software.

Using Snapshot standby and flashback DB features.

ADDITIONAL STRENGTHS

Project Planning and Project Management Vendor management Onshore and offshore collaboration

Onshore work experience (USA)

CERTIFICATIONS

Certificate of Recognition - Oracle Database SQL Certified Associate.

Certificate of Recognition - Oracle Database 12cR2 Administration Certified Associate.

Certificate of Recognition - Oracle Cloud Infrastructure 2019 Cloud Operations Certified Associate.

Certificate of Recognition - Oracle Autonomous Database Cloud 2019 Certified Specialist.

Amazon Web Service (AWS) Certified Big Data – Specialty.

Information Technology Infrastructure Library (ITIL) Foundation certificate in IT Service Management (ITSM).

EDUCATION

Master of Computer Applications from Sikkim Manipal University, Sikkim (2016)

Bachelor of Commerce from D.D.U. Gorakhpur University, Gorakhpur, Uttar Pradesh (2007 - 2010)

Intermediate Examination (12th standard - UP Board) from S.S.G. Inter College, Ballia, Uttar Pradesh (2006 - 2007)

Contact this candidate