Vp, Supervisor/lead Database Architecture Resume
SUMMARY:
- Experience with planning, design, system architecture, management, leadership, team building skills, build strong working relationships as required to meet business needs, new thinking, practical tools and implementation services.
- Implemented Big Data analytics platform using Hortonworks Hadoop multiple clusters across two datacentre’s. Provided administrator support to the new Linux platform.
- As a lead of administration team monitoring, manage on - site consulting team in their daily activities as well as supporting business projects, day to day operations and data administration. Installed, configured and implemented Web based tools Hadoop Ambari agent and services on Hadoop cluster servers.
- Ambari provides an in-built, user friendly Hadoop management web user interface. Configured and administer Pentaho (a very capable hybrid open source data model and fully functional), OBIEE, and OFSAA (enable financial institutions to measure and meet risk adjusted performance objects, culture, lower the costs of compliance and regulations and improve customer insight) with Enterprise Risk Integration program. Experience with high-performance, distributed, enormously scalable and highly available architectures.
- Installed, configured Puppet Enterprise 3.7 to manage the environments.
- Hands-on experience of implementing Big Data analytics platform with Hadoop framework.
- Develop and manage relationships with vendors in support of staff augmentation and systems support. Develop and implement software standards for databases and applications. Develop and implement data retention periods, Develop and maintain overall backup and recovery strategy.
- Establish and implement best-practice standards as well as policies and standards. Manage the day-to-day operations of the IT group including downtime, reporting service levels, defining and tracking IT operational metrics and provide status to management.
- Using Remedy/IT portal requests initiate, manage, support and promote the necessary production changes. Manage priorities and timelines of project tasks. Estimate, plan, and implement new business capabilities. Develop project scope and definition.
- Provide IT project management leadership/Large infrastructure to the team for database maintenance, production timetable, status reporting, client/project team coordination and quality assurance. Maintain, track and report on the status of projects.
- Describes best practices in managing, measuring and monitoring software development processes. Strong experience with Linux/Unix/Solaris/AIX operating system, BCV backups using EMC technologies.
- Manage overall capacity utilization of database/application environment ensuring it is optimized to meet business requirements.
- Analyze data from multiple systems and sources to ensure that the audit teams act proactively on risk trends and exceptions.
- Development and execution of test cases with requirements and expected results. Ensure adherence to company and technology standards and methodology. Troubleshoot issues and batch support to ensure high levels of application availability and accuracy along with high reporting application availability.
- Adapted CMMI models into the database/application architecture group for collections of best practices that helps improve effectiveness, quality, verification, validation and good practices to help the team to work on right paths.
- As an experienced supervisor/team leader vision through strategy, design, architecture, analyze and solve problems to increase customer satisfaction, management expectations and control costs through expertise in (lead database architecture group, cross functional teal leadership, organize internal staff group meetings, and end user team leadership).
- Demonstrated skill in organizing workflow from group planning sessions through implementation in variety of media and capitalizing on primary competencies of technical, design teams and document team meetings.
- Experience in multifaceted architectural design, implementation, results oriented technology and business leader with depth and breadth of knowledge & expertise in many areas of technology, Oracle EXADATA/ERP/LAWSON Financials/Energy Utility applications (CC&B and Outage Management System), Oracle BI, Oracle Financial Services Analytical Applications Infrastructure, Oracle WebLogic Server 11g, Oracle OBIEE Fusion Middleware, operations, project management, and change management. Configured Oracle Enterprise Manager (OEM) 12c/11g with Oracle RAC environment.
- Managing an onsite and offshore DBA specialists support the applications for the approximately 30,000+ users spread across all over the world. Communicate and coordinate resources at many levels.
- Manage global projects with the strategic goal of delivering business solutions, stipulated time interval, within a defined scope.
- Work with Database Admin team/consultants and senior development team to invent project plans for large-scale projects.
- Very strong in database architecture, administration 11g/10g/9i/8i/7, planning, configuration, data modelling, data storage technology, backup/recovery, tuning, Oracle Grid, and security of business applications.
- Ability to lead large-scale database projects, management experience and to work in a strong team oriented environment.
- Promote open communication, motivates others, and provides coaching and counselling to team members.
- Successes in steering a complex and fragmented environment towards simplification and future sustainability.
- Ability to present complex information in a way that is equally understands by both, business and technical experts.
- Well versed in high availability solutions like Oracle Exadata, RAC, Oracle Replication, Data Guard, Disaster Recovery and Clusters failover solution.
- Ensure projects adhere to corporate technical architectural standards, unified methodologies and best practices.
- Outstanding ability to understand customer requirements and recommend the most appropriate technology solution. Always successful in meeting new technology challenges and finding solutions to meet customer needs.
- Work experience in legacy and emerging technologies, database, application architecture, system design, implementation, project and methodology design.
- Knowledge of Experimental design to reduce design costs by speeding up the design process. Follow the procedures to understand the role of requirement, define the requirement with more details, and recognize the requirement changes.
- I have a best guidance skills, documentation and metrics related to the practices involved in managing and implementing projects. I have initiate and plan the project by establishing its format, direction and base lines that allow for any variance measurements and change control. Worked with end users, work with vendors and other management to establish progress and direction of the project by achieving goals, reaching targets, solving problems and mitigating risks.
- I can understand how to build and maintain positive client and peer relationship, capabilities in evaluating new techniques and utilizing the key elements with all my existing skills, confidence to manage tasks, issues, priorities and interdependency’s. Strong work ethic, initiative, teamwork, and flexibility to assist department in meeting organizational goals.
TECHNICAL SKILLS:
Big Data Services: HDP 2.1/2.0, HDFS, Installed R packages Hadoop (rmr2, rhdfs), MapReduce, Nagios, Gangila, Hive,HCatalog, HBase, Oozie, Zookeeper, pig, flume, sqoop, and Kerberos Security.
Modules: Financials (GL, AR, AP, Fixed Assets, Cash Management), MRP, Order Management, Oracle Supply Chain Management, and Oracle Projects.
Web Servers: Fusion Middleware, OBIEE 11g, WebLogic Server, WebSphere, Apache, Java/J2EE and Tomcat
Internet: Oracle SSO, Apache Server, Jserver, HTML, Portal, XML, Jinitiator, and JDeveloper.
Case Tools: E-Rwin, BP, Designer, and Microsoft Office/Visio/Lynx.
Languages: C, SQL, PL/SQL, Korn shell, Perl and Pro*C.: -*
Backup Software: Recovery Manager (RMAN), BCV and SQL*Backtrack.
Third Party Tools: Toad 12.x, Precise, ADSM, Tivoli, Quest Spotlight, Primavera, MAXIMO, BSI TaxFacotry, ArcSDE, and PowerTerm BMC Patrol, EMC powerpath to support SAN storage on CX300, MS-Projects, Unicenter DBA, Patrol Performance manager, Platinum Desktop DBA, SQLab and SQL*Station.
Hardware/OS: SPARC Enterprise Sun4v 64-bit, RHELinux Version 2. . el6.x86-64, CentOS release 6.5, IBMAIX/Linux/Solaris/HP/Windows /NT/98/95
PROFESSIONAL EXPERIENCE:
Confidential
VP, Supervisor/Lead Database Architecture
Responsibilities:
- Lead and responsible to work with in-house Hadoop development with vendor Hortonworks. Currently, we are in process of upgrading HDP 2.0 to 2.1 for the lab and testbed environments. Expert in the technologies ultimately deployed as part of the architecture. Confirm designs, configuration, codes and documentation is in line with the enterprise strategies, methodologies and standards. Configuring Kerberos-based security in the Ambari Web GUI, Principals and paths to keytabs.
- Supported strategic DBaaS (database as a service) to support company-wide business extreme programming platform. DBaaS is built upon Oracle 11gR2 RACs and replication across data centers.
- Implemented Big Data analytics platform using Hortonworks Hadoop multiple clusters across two datacentre’s. Provided administrator support to the new platform.
- Installed Hortonworks Hadoop framework using Ambari, installed and configured R for Hadoop.
- Configured Kerberos security on all Hadoop clusters including cross domain authentication.
- Set up and configured Name Node HA within each Hadoop cluster.
- Developed UNIX shell scripts to support HDFS and Hive replication across Hadoop clusters.
- Configured HBase replication between Hadoop Clusters residing at different data centers.
- Developed UNIX shell script for user on-boarding and support of multi-tenancy.
- Experience of statistical tools and software (R & SAS) and techniques used for data analysis and modelling.
- Experience with data collection, standardization of data from database.
- Responsible for providing Team leader/senior level consulting and managing multi-million dollar EXADATA/E-commerce/ERP application database complex and highly critical database issues.
- As a lead of the group develops data architectures, database management policies and standards for use with the organization.
- Installed, configured Oracle 11g Clusterware/RAC/ASM environment.
- Implemented sound RMAN backups and recovery procedures in ASM environment. ASM setup of disk groups for the database and flash recovery area.
- Implemented and tested Maximum Availability Architecture using Data Guard role transitions including testing switchovers, manual failovers and fast-start failovers.
- ASM setup of disk groups for the database and flash recovery area.
- Improve productivity with integrated imaging, workflow and spreadsheet integration. Manage enterprise risk and reduce compliance costs with end-to-end process for risk and compliance.
- Provided thought leadership in large deal pursuits - understanding the client needs, competitive situation analysis, strategic planning, consulting on selection, design, development and integration of multiplatform and distributed databases.
- Build trust with our clients by increasing value ads and making them successful in their goals and objectives. Value driven approach to solution creation, focus on customer intimacy, satisfaction and sound relationship.
- “Over the years, Private Work Bench system has become very complex and keeping them up and running with minimal downtime is very critical to our business and for overall success of our company. We often face with very tight project timelines that we also need to accomplish among other things We, Private Work Bench team, are very fortunate to have Sada Kokkula support to us even if it’s in the middle of a night or in the middle of a weekend. The most compelling reason, however, that prompted me to write this to you is Sada Kokkula highly proactive nature that I witnessed when Private Work Bench team data lead decided to move on to other organization few months back. Sada’s silently took over many of the day to day housekeeping activities that out data lead used to do to make sure we have a healthy and well performing system even before I formally requested him to do so. I really admire his strong commitment and diligence that he has demonstrated every day and his contribution to make Private Work Bench application successfully.”
Confidential, Miami, FL
Lead DBA/Infrastructure
Responsibilities:
- Lead full lifecycle database architecture, planning, implementation and administration for Norwegian Cruise Line application production databases.
- Data Centre Consolidation
- Involved to produce and maintain a capacity plan as well investigate and diagnose performance related incidents.
- Responsible for all aspects of performing project application and database changes as a group lead.As a team lead provided support for the infrastructure architecture and application database administration for Oracle ERP R12, Oracle Business Intelligence Enterprise Edition, support day to day production issues for E-business Suites including application server, database server, system administration, and workflow administration.
- IT strategy, planning and operations for the company.
- Documented daily/weekly maintenance routines and developed escalation paths for on-call tickets. Also, encompass projects, upgrades and migrations as needed to support growing business.
- Responsible for all aspects of project management, change management and performing project planning and prioritization.
- Developed environment and resource plan for Oracle Financial projects. Integrate business change with the best in class processes, centralized global services and meet varied reporting standards with a flexible accounting model.
- Integrate risk and performance analytics to reduce the costs. Minimize errors, red flags and inefficiency with control monitoring.
- Help with third party configurations, troubleshooting, printer setups and Oracle Discovered tools.
Confidential
Infrastructure Architect/DBA
Responsibilities:
- Architect, implement and support all activities pertaining to future code enhancements, Oracle Business Intelligence Enterprise Edition databases upgrades.
- My role includes analyze requirements, architecture IT solutions using databases, debug and recommend performance techniques, and capacity planning.
- Led performance testing initiatives, implemented a project summary providing advice and recommendations for the best practices.
Confidential, San Francisco, CA
Lead Application Architecture
Responsibilities:
- Involved as Lead application architecture includes eBusiness suite application performance hardware & software review, assessment, server and storage capacity planning.
- Installed third party tools monitored the operating system and database for performance and stability problems can have a serious impact on the company’s continued success in the United States market, and on its planned global expansion.
- Led conversations and communicate the project status and recommendations with upper management.
- Responsible for providing lead DBA support for operations and technical leadership for code migrations and test builds.
- As a member of Lead DBA layout architecture/administration, installation, upgrades, patches, TAR support, tuning, cloning, backup, recovery for Oracle eBusiness/Utility applications SYSADMIN and concurrent manager administration.
- Responsible for project plan tasks list, communications planning, create change control procedures/updates, conduct group meetings, efforts, resolve technical issues and on call support 24X7.
- Installed, configured and implemented Oracle Utilities CC&B and Outage management application.
- Implemented and tested Maximum Availability Architecture using Data Guard role transitions including testing switchovers, manual failovers and fast-start failovers.
- Reducing the complex tasks of diagnosing and correcting application performance problems.
- Build a legacy applications (Project Accounting Asset Management), Outage management system, Lawson Financials (HR & Payroll), and MAXIMO using Oracle RDBMS on UNIX environment.
- Managed the performance of Oracle database environments by providing unique functionality such as identification of performance bottlenecks, guided problem resolution, and comprehensive system monitoring.
- Set the priorities and escalations procedures for higher version upgrades for the company.
Confidential, Pittsburgh, PA
Principle Consultant
Responsibilities:
- Carried out analysis, design, development and implementation of the RDBMS system.
- Installed, configured, upgraded, implemented sound backup and recovery policies and procedures for a Oracle server software and related products.
- Performed capacity planning and security procedures for all production databases.
- Extensive support for application developers to user correct SQL code with a new Oracle software release for better performance.
- On call support 24X7 for all production databases.
Confidential
Sr. Systems Engineer
Responsibilities:
- Led the Passport Control System development, analysis, design, testing and implementation for computerizing the Passport and Emigration activities of all the Passport offices across the Country, India.
- Designed menu’s using Forms and Menu Language Interpreter (FMLI) of SCO UNIX.
- Created and manages users, ensuring proper access and security.
- Conducted testing and code review of the whole system according to prescribed standards.