Over 10 years of diverse IT experience. Extensively worked on various database platforms which include Administration, analysis and design, Development, ETL & Data warehouse, Reporting Framework, tuning of various database performance issues.
Around 4 years of programming Experience in (Postgres, Oracle) development experience in Enterprise Applications from requirement gathering to design, development, testing, post production support and bug fixing.
Around 5 years of Administration Experience on Oracle, Postgres.
Experience in Migration which includes entire migration life cycle.
Good Data Analysis skills, Ability to review and manipulate large sets of data (mainly in MS-excel)
Hands on experience in Data Modeling tool
Thorough understanding with ODI, IBM Datastage, IBM netezza analytics, Informatica, Cognos and other open source ETL & BI platforms
Experience with ETL process & Data Warehouse and end to end delivery.
Experience with performance monitoring tool like Oracle Enterprise Manager and TOAD.
Expertise in analyzing Database ADDM, AWR, ASH, TKProf and SQLplan reports.
Good in SQLLoader, IMPDP and EXPDP
Expertise in creating database objects like procedures, Functions, Triggers, Cursors, complex sql Queries and sequences.
Experience with Version Control tools like CVS, git, SVN.
Working exposure to Agile software development life cycle (iterative and incremental methodologies).
Experienced in all phases of the Software Development Lifecycle (SDLC), Software Test Lifecycle (STLC) and Performance Test Lifecycle (PTLC).
The above experience includes experience in managing a team and responsible for coordination with various stakeholders, involved in client communication and direct reporting to client and responsible for project deliverables.
Expert ability to identify database bottlenecks, design risks, and issues.
Analyze end-to-end performance issues, covering back-end performance tuning knowledge
Triage and drill down customer pain points, key business flows analysis and bug filing/follow ups, attend and resolve show stopper escalations.
Performance testing experience includes Benchmark, Load, Regression, Capacity and Scalability.
Expertise in Project Management Activities including preparing proposals.
Proficient in both development projects as well as support projects
Communicating and working with different teams like Application Developers, Product Specialists, Systems Engineers, Network Engineers and System Administrators in understand Performance Objectives, Volumetric, setting up DB Performance Goals and Define SLAs.
Expertise in preparing Quality Procedures, Test Strategy, Test Plan, Test Cases, Test Data, Analytical Reports and Test Approach.
Ability to communicate effectively with different levels of management, as well as both the business and technical communities and work independently to understand the application, Creating Test Plan & Strategy, Identifying Key Business Process