Sr Database Consultant Resume
Milpitas, CA
SUMMARY:
- Add Unique Value to Enterprise Managed Cloud Hosting by Increasing Performance & Availability
- An experienced Oracle Technical Client Manager(TCM) and Lead TechOps professional having expertise in Managed IT Service industry (Databases & Packaged Applications ), including full database lifecycle management (change, compliance and configuration), with experience in oracle Suite of products and other database technologies (MSSQL, MySQL and MongoDB ). Employ passion for reducing improving infrastructure builds, on - permise to cloud migrations, reducing downtimes and improving performance, finding gaps and coming up with new ways to monitor and troubleshoot pressing issues.
- Experience in Managing Application Services, built on proprietary NaviCloud (NCD), using combinations of IAAS, PAAS and SAAS models.
- Exposure to specific services within Oracle (OCI), AWS and Azure cloud services.
- Experience architecting, migrating, and developing technology solutions with Oracle, AWS and azure public cloud.
- Automation experience in Database and Linux provisioning operations.
- Adept at communicating complex system solutions and architectures in simple terms to executive management on both sides.
- Explain complex technological solutions and concepts to users and non-technical decision-makers using effective written and verbal communication skills.
- Training, managing and mentoring DBA team members at customer sites and offshore.
- DevOps & Enterprise Architecture
- Build, configure, and manage Database & application instances and data storage on-premise & private and public Cloud (NCD,OCI,AWS & Assure) for multiple instances of AWS and Azure.
- Technical point of contact for customer, project managers, resource managers and the NOC for any client’s technical issues. Management or resolution of technical issues within a timely manner.
- Investigate and Coordinate root cause analysis (RCA) on IM1 and IM2 tickets and putting effort to minimize future occurrences .
- Designing and Implementing HA Systems using Real Application Cluster (RAC), Data Guard, Snapshot Standby Database, Oracle concurrent managers failover and loadbalancing (PCP), Reverse Proxy Setup using Apache as TLS, H/W Loadbalancing of application servers, Jserv loadbalancing and forms loadbalancing.
- Participate in change control boards, and design review committees Identify areas for business/ IT process improvement and efficiencies; make recommendations to improve existing processes or system functionality.
- Work with infrastructure team in automating provisioning of Linux and oracle/Mysql/Mongo VMs . Creating Oracle database, users and applying PSU patch Using Ansible Tool.
- Understand available support and triage technical work requests to appropriate resources to address customer technical issues, provide guidance to expedite issues internally or with outsourced resources.
- Provide on-call support and facilitate communication with the SME, CSE and networking groups (if applicable) and customers in the event a situation will impact their service window.
- Provided optimal technical service support and management for customer technical operations, maintaining client relationship by proactively managing applications environment, including Managed Application Services (on-premise & Cloud).
- Understand the customer’s technical environment completely and ensure the creation and maintenance of documentation of such.
- Simplified, reviewed, deployed and improved automation of alerting, monitoring, maintenance, backup / recovery and business continuity / disaster recovery process by providing and authoring SOPs, configuration specifications and related technical documentation.
- Built top-notch 24X7 support model from ground up, with technical and functional contributors, affecting DBA Engineering / Operations, Platform Services Engineering / Operations, Change Management, Testing and Automation.
- Developed strategy to maintain and support ERP Databases and Application, maximizing availability and uptime, reducing licensing cost and improving Disaster Recovery (DR) preparedness and plans.
- Consolidated operations support structure into scalable 7x24x365 offshore operating model by implementing necessary staffing and training.
- Designed and implemented Oracle load monitoring program used throughout datacenter, enabling on-call support DBA team members to corner issues causing load spikes.
- Spearheaded Cloud computing initiative, migrating DR environments from on-premise data center to Cloud (NaviCloud, Oracle, AWS and Azure), and delivering huge CAPEX savings for customers.
- Directed large Enterprise Application implementations, overseeing offshore resources as Infrastructure Lead.
- Steered major data center migration projects, developing, maintaining and communicating Business and IT strategies.
- Identified opportunities for operational efficiency through innovation and integration, analyzing and evaluating systems for consolidation and optimization.
- Created collaboration and efficiency within highly matrixed environments, developing partnerships with crucial internal / external stakeholders, and executing strategic and operational initiatives, shortening delivery times and providing substantial savings.
EXPERTISE IN:
- Database Support
- Performance Tuning
- ERP Build, Support, Upgrades & Migrations
- DR & HA Setups
- SOX Governance & Compliance (HIPAA, PCI) | ITIL
- Transparent Data Encryption
- Operation Management
TECHNICAL SKILLS:
Hardware Systems: HP-Servers, Dell-Linux servers, Sun systems (SPARC) T series and V series, NetApp appliances, including Flex Clone, ICL DRS6000; IBM ES-9000, Pentium Workstations
Operating Systems: UNIX (SUN, HP, LINUX, AIX), Windows NT, 95, 3.x, CMOS/JCL & DOS
Database Systems: Oracle, SQL Server, MySQL,MongoDB, Hortonworks Hadoop
Oracle Products: Oracle EBS (11i,12.1,12.2) modules, Oracle Business Intelligence products, Demantra, Primavera (P6 EPPM suite) 15.X, 16.X, GoldenGate, Oracle Governance, Risk & Compliance Control (GRCC), Configuration Controls Governor (CCG)
Cloud Computing: NaviCloud, Oracle Cloud, Azure, AWS
Storage System: IBM XIV, NetApp FAS storage systems with Netapp filer, Flex clone, HP, EMC
Software Tools: Unix shell, PowerShell, Oracle Data Guard, Oracle GoldenGate, SQL-Developer, Toad, Oracle Designer, ERWIN, SQL plus, Access, C, Java, Perl, Python
Software Methodologies: Software Development lifecycle, Waterfall Model, Evolution model, Prototyping, CASE, RAD, DevOps Continuous Deployment Model
Quality Standards: Quality focus with ISO 9001 and SEI CMM Level 5 standards
PROFESSIONAL EXPERIENCE:
Confidential, Milpitas, CA
Sr Database Consultant
Confidential, San Jose, CA
Sr DBA and Architect
Responsibilities:
- 16+ years designing and deploying mission-critical relational database solutions in distributed Linux-based enterprise environments.
- Managed highly transactional OLTP Databases(Oracle, MySQL, MSSQL) and No-SQL(MongoDB) reducing downtime maintenance window and increasing performance and throughput during critical business cycles.
- Experience in setting up database security rules and policies i.e. Fine-Grained Access Control and Transparent Data Encryption (TDE), on both Oracle and MSSQL databases. Experience in setting up database security rules and policies i.e. Data Redaction, Database vault, Fine Grained Access Control (using VPD ) and Transparent Data Encryption (Tablespaces & Columns ), on both Oracle and MSSQL (Columns ) databases .Using oracle key-vault and OS folders for keeping the master keys .
- Hands on experience running cloud infrastructure in public clouds like NCD(Navicloud), OCI, Azure & AWS .
- Some of my very recent oracle cloud experience includes: - Creating an Instance of Oracle Public Database Cloud (DBaas), MySQL Cloud Service, Creating Storage Containers for Backups, Provisioning a New Oracle E-Business Suite Installation on Oracle Cloud Using the EBS Cloud Admin Tool, Creating an Oracle Database Cloud Service Instance(DBaaS), Cloning Oracle E-Business Suite From On-Premises to Oracle Cloud Using EBS Cloud Tools, Managing Oracle E-Business Suite on Oracle Cloud Using the EBS Cloud Admin Tool, Configuring Oracle Workflow Notification Mailer with Mail Servers for Oracle E-Business Suite Using the EBS Cloud Admin Tool, Accessing data using RESTful Web service.
- Some of my AWS experience includes, creating AWS (RDS, AURORA and S3 storage ) cloud services. Install and configure Oracle Database 12c EE and Oracle E Business Suite AWS with high availability. Exposure and very good understanding about various AWS cloud infrastructure components such VPC, Availability zones, Elastic load balancing, EBS GP2 volumes, Route 53, Monitoring services through Clouwatch & Cloud Trail, setting IAM components i.e security groups,Roles,Policies and API keys.
- Implemented New Database technologies such as multi-tenant container databases and in-memory databases, and partitioning and adaptive execution plans, providing pro-active tuning by using ADDM, AWR and ASH performance report metrics.
- Worked with EBS (11i to 12.2.X ) suite of modules and fine-tuned technology stack, delivering best throughput and optimal performance.
- Fine-tuned 12.2.x managed server tech-stack and deployment plans from default settings to production ready.
- Optimized databases for month-end closings and for supply chain planning runs.
- Tuned SQL statements and reorganized online tables and indexes for optimal performance, assisting development team in monitoring and tuning SQL queries using EXPLAIN PLAN and TKPROF utilities and multiple Oracle internal performance and diagnostic tools.
- Managing MongoDB installations, creating 3 to 5 node replicasets, Shard cluster setup, user management, capacity planning, monitoring mongodB processes using mongotop and mongostat, helping the DBA team during upgrades and monitoring performance and creating indexes, exposure to tuning MongoDB Aggregation queries, taking backups of databases and collections using mongodump and importing them across to different environments as needed . Configuring Sharding and monitoring the clusters.
- Installations, taking backups using MySQL dump, xtrabackup (percona) Data export and import with Workbench, Restoring using mysqlbinlog, Monitoring MySQL with Performance schema, MySQL query optimization and performance Tuning, indexing for performance and setting up replication (RBR and GTID) and monitoring integrity using pt-table-checksum tool . Setting up MySQL Master/Slave Replication both on premises and Cloud
- MSSQL Server experience includes: - Experience in providing support to MSSQL databases including Installations, Instance Configuration, performance tuning, taking backups and restoring for cloning, auditing and setting up encryptions. Looking into common query tuning problems and performance patterns and Query plan analysis, performance Troubleshooting using wait Statistics, collecting Troubleshooting data, Deadlock Analysis and Prevention, Collecting and analyzing trace data, Auditing SQL Server, setting up server- level and database-level security . Well versed with transaction logs and recovery models, taking backups using PowerShell and stored procedures. Improving SQL server Performance with Compression. Using DMV and dynamic management functions for finding out long running queries
- Provided support to MSSQL databases, performing installations, instance configuration, performance tuning, taking backups and restoring for cloning, auditing and setting up encryptions.
- Installed and configured Oracle RAC and TAF, ensuring 24/7 availability, performance and scalability.
- Set up database security rules and policies on Oracle and MSSQL databases, tightening security around confidential data and maintaining audit compliance.
- Shortened build and patching time by developing scripts using SQL, PLSQL, Unix Shell and Power Shell, and Ansible.
- Engaged in Production Support activities, working in 24x7 production environments as part of on-call rotation team.
- Designed in-house monitoring tools, eliminating need for customers to purchase third-party licenses.
- Migrated databases and applications from on-premise to cloud services, using combinations of IAAS, PAAS and SAAS models, and accessing specific services within Amazon, Oracle and Azure cloud services.
- Participate in Sales Handoff session for new customers.
- Work with PM on request provisioning of systems from Pre-production services, monitor progress, communicate with customer if needed.
- Ensure proper flow of requests for testing resources once the build gets completed.
- Host prove-out sessions upon provisioning completion with Professional Services \ Partner resources.
- Respond to Customer requests for miscellaneous technical requests that will require less than 16 hours of service.
- Responsibility to validate request, scope, request correct contractual documents, initiate Change Control Processes and hand-off to appropriate Provisioning Manager, Change Implementer or outside consultant for scheduling and completion.
- Take ownership of SOP’s, Configuration Specifications and related technical documentation. Maintain Documents and Qualification Support: Develop/Maintain SDLC documents, SOPs, User Training Document and other application verification and testing documents .
- Follow-up with Customer upon completion of request to check satisfaction.
- Participate in new customer Go-Live meetings, providing technical expertise surrounding customer’s technical environment: and Confidential procedures.
- Review project status with client managers on an ad-hoc basis, noting any potential issues or problems related to the customers technical environment.
- Provide advice/information to Client Managers on appropriate client issues (consultant / contractor skills, client attitude and temperament).
- Responsible for a customer’s transition from an implementation /provisioning project to a maintenance mode with the Client Management, Customer Care and Technical support organizations.
- Provide proper ownership of customer technical issues in the support organization (L1, L2, L3, Provisioning, Outsourced resources).
- Accept tasks for high-level application related questions, resolve or determine appropriate resource
- Assist in responding to requests for information raised by the customer, internal management, or SAS70 auditors.
- Watch volume of customer service requests for trouble areas and escalate to management when open issues are likely to cause customer satisfaction issues.
- Understand available support and triage technical work requests to appropriate resources to address customer technical issues, provide guidance to expedite issues internally or with outsourced resources.
- Provide on-call support and facilitate communication with the SME, CSE and networking groups (if applicable) and customers in the event a situation will impact their service window.
- Consistently assist other Technical Client Managers with technical issues.
- Responsible for identifying and assisting Account managers and Internal Sales in up - sell opportunities.
- Responsible for assisting Client Management for renewals of Naiveite s direct hosted customers, communicating with management if assistance is needed
- Understand customer contracts and keep track of updates issued specifically in the areas of security, user managementand software licensing.
- Prepare and develop statements of work, Review Change Orders, and Technical Change Requests of validity and appropriateness of the technical aspects of the solution for new and existing customers.
- Provide feedback to sales on project technical issues to assist in refining future proposals.