PROFESSIONAL SUMMARY:

• Self - Motivated, accomplished, detail and result oriented software professional looking for a next play in progressive organization with over 16 years of experience in enterprise level big databases design and architecture, management and operations.
• Technical authority in development of very large (~100 TB) Oracle/MS SQL Server/Hadoop/Green Plum/MySQL Post Transactional Database, OLTP DB’s etc.
• Extensive experience in strong execution focus in innovating, designing, leading and delivering complex projects on time.
• Strong team player and tech-lead with proven ability to lead and motivate high performance teams.
• Led t he design and execution of scalable and distributed ecommerce applications to highly resilient geo located data centers with Disaster Recovery and High Availability failover.
• Strong contributor to open source databases ( Cassandra, Redis, Mongo DB) development.
• Researched and started executing policies related to SOX and PCI compliances.
• Experience working with rule base access control (RBAC).
• Excellent analytical, diagnostic thinking, interpersonal and communication skills.
• Oversaw 100% compliance of meeting SLA and KPI’s in accordance with infrastructure service delivery.

TECHNICAL PROFICIENCIES:

Languages: C/C++, Java, JavaScript, Shell scripting, Python, Perl.

Databases: Oracle 12c/11g, MS SQL Server, MySQL, Cassandra, Postgres, Redis, Mongo, Oracle EBS

Big Data: Hadoop, Green plum DWH.

Tools: Grid Control, SQL Developer, TOAD, Red-Gate, Veridata, SolR, Automation frame works, Scala, Kafka, Spark, Hive, IBM Mqueue, SVN, Bamboo, Tableau, Nagios, Ganglia, Splunk, Others: Dockers/Containers, Public/Private Cloud, SaaS, PaaS, Accurev/GitHub, Agile, Jira, Viper, AWS EC2, AWS Elastic .

WORK EXPERIENCE:

Confidential, Foster City, CA

Lead DBA, DevOPS

Responsibilities:

• Managed operations and infrastructure team of 15 brilliant and energetic engineers.
• Led the execution of scalable and distributed ecommerce applications for payment processing to Active-Active with automation infrastructure across various data centers with the help of cross functional teams (PD, Application, Network teams).
• Implemented data scrubbing and data masking using Golden gate to save multi-million dollars for QA team.
• Architect the strategy and design to create a Data Lake from various data points for data scientists to detect various behavior and patterns for fraudulent transactions.
• Led the growth of various projects (Tier 0, Payment Gateway migrations, Cassandra deployments on a fast paced transactional platforms, Peak Season Readiness, Simplifying change management, Security Audits, Successful/Smooth database switches with five nines availability).
• Managed a cluster of 60 nodes (4 logical clusters) Cassandra Cluster.
• Responsible to drive the complex investigations of production issues in a timely manner which resulted in highest customer satisfaction and increase overall business revenue.
• Deep thinking with great adaptability, think ahead approach, bold ideas, innovative thinking to do things different way with positive attitude to ensure the deliveries were smooth, solid and met customer requirements which resulted in innovation within an organization.
• Stayed focused, constantly engaged and consistently delivered quality results within promised time-frames and per client expectations in a way to inspire others.
• Asked thought provoking questions during the projects/productions issues troubleshooting to stimulate out of the box thinking and challenged assumptions to rely on fact based data.
• Stayed focused on quality, worked effectively and efficiently with all team members; provided encouragement, offered appropriate assistance and support to colleagues and superiors within area of expertise, without waiting to be asked; participated in cross-functional teams.
• Extensive experience in fraud prevention strategies, rules, predictive models and analysis in financial domain using Artificial Intelligence which required to work with cross function teams of data scientists.
• Created easier to digest incident reports for upper management for critical issues in presentable format which resulted in quicker adoption of uniform reporting style.
• Defined and developed database migration strategy of Sybase to Oracle, MySQL to Oracle using golden gate replication which reduced the overall cost by 20%.
• Stabilized the execution plans using SQL plan base lines for Business reports which help meeting the SLA.
• Defined the automation strategy of Database releases and maintenances on Oracle/SQL Server/Cassandra/Sybase which reduced the overall release time and man power.
• Technical authority on various High Availability replication technologies such as Golden Gate Replication, Data Guard in homogenous (Between SQL Servers, Oracle) and heterogeneous environments.
• Extensively worked on Viper Incident, Problem, and Change Management.
• Implemented F5 LTM Load Balancers iRules, Priority based load balancing method and created out of the box health check techniques with 30 seconds timeout to fail-over.
• Created a webpage and documentation having links to all business as usual activities, patching/upgrade, space usage dashboard, DB connections information.
• Drove the execution of Business plan and strategy to follow the SUN model.
• Integrated agile software development principles with operational excellence which resulted in high performing team.
• Performed Schema/Data comparison using Red-Gate and home grown scripts for SQL server/Oracle respectively.

Confidential, Santa Monica, CA

Staff Database Administrator

Responsibilities:

• Worked with infrastructure and systems operations group to do capacity planning, troubleshoot production issues and benchmark testing.
• Designed and implemented Oracle 11g R2 RAC with golden gate.
• Worked on Data Warehouse (Green Plum) data center migration strategy with 0 downtime which resulted in 40% savings of money.
• Benchmarked testing on direct NFS on Oracle 11gR2 with sun storage Amber road.
• Automated daily DBA Tasks via scripts (schema refreshes, encrypting Data etc.) and Grid Control.
• Defined, designed and implemented disaster recovery solutions on Oracle database 10g environments.
• Was responsible to design and develop automatic failover using load balancer to achieve high availability.
• Worked with cross functional teams to come up with SQL based solution to eliminate dependency on SQL code generated by Hibernate (Java) which resulted in high performing and accurate application.
• Automated the process of monitoring oracle databases 24X7 using OEM Alerts.
• Used advanced partitioning techniques of Oracle 11g.
• Secured production data using Virtual private database and Oracle wallet manager.
• Automated the process of business reporting for Product/Project Management teams.
• Automated the process of refreshing/restoring/rollback databases using production database backups using physical/logical backup tools like RMAN/exp/expdp.
• Worked on proof of concept on open source databases like Postgres and MySQL for various projects.
• Quickly learned and implemented SOX and PCI compliance and implemented wherever required.
• Worked on management/tuning/releases on Data Ware house.
• Worked with developers on Index tuning, Partitioning, Creation of Triggers, Database fragmentation & compression, Alerting, Backups.
• Applied Patches & Hot fix time to time recommended by Microsoft.
• Implemented and maintained database replication using clusters for blogging sites (American Idol, Fox Sports, and Fox Television etc.)

Confidential, Los Angeles, CA

Senior \DBA

Responsibilities:

• Worked with Engineering, Global Services, and Sales Team to Design and Create Databases (Oracle Database 9i and 10.2.0.3) and schemas as on Red Hat Linux (RHEL 4 and RHEL 5) and Windows when need arises.
• Led investigation of the database for memory and performance related problems and fix them all.
• Created, customized monitoring settings, automated problem resolution with corrective actions, creation of user defined metrics.
• Participated on database and application releases with various web servers.
• Participated In physical design of databases and recommended partitioning joins on Tables whenever required.
• Worked on Oracle Streams and Online Schema management.
• Performed refreshes in Staging/QA and Dev/Dev-Integration, databases Environments on site as well as on client sites.
• Wrote automated scripts or refreshes (schemas), monitoring activities in Production Databases in Linux Environment.

Confidential, CA

Lead Oracle DBA/Data Architect

Responsibilities:

• Managed three node Oracle 10gR2 RAC running on Sun Solaris 10.
• Upgraded from Oracle RAC 10.2.0.1 to Oracle RAC 10.2.0.3 environment.
• Performed effective vendor management which resulted in reduced oracle license cost.
• Wrote automated scripts for refreshes (schemas), monitoring activities in Production Databases in UNIX Environment.
• Wrote Automated Scripts for RMAN level 0(Full backup) and level 1(Incremental backups).
• Actively worked on database designing and architecture for new and old projects in production environments.
• Worked on Oracle Data Guard for Physical Standby Configuration.
• Worked on Advanced queuing on Oracle.
• Proven experience in a 24*7 Production Database support role.