Technical Skills

RDBMS: Oracle 11g R2/10g/ 9i/ 8i, MS SQL Server (2012 R2/ 2008 R 2/ 2005/ 2000/7/6.5 ), PostgreSQL and IBM DB2

Big Data: Hadoop 2.x, DataStax Enerprise (DSE)

Applications: Oracle Business Intelligence Enterprise Edition (OBIEE) 11g, Oracle E - Business Suite R12.2.x and R11i, Oracle/ PeopleSoft 9.x/8.9x:, Financial Supply Chain Management, Enterprise Performance Management, Human Capital Management, Enterprise Portal, Oracle Transportation Management, Oracle Governance, Risk and Compliance (GRC), Oracle Configuration Controls Governor (CCG), Agile scrum, AdvantX, Amkai, Meditech, Cerner Millennium, Paragon, PACS, PMSI, Epic, SIS, Oracle Customer Relation Management (CRM) and various Change Management solutions

Servers/ Massive Parallel Processing Servers: IBM Netezza appliance, IBM xSystems, IBM Power Server 7xx, Oracle Exadata V2, Oracle Sun Fire V890s/V1280s, HP DLxxx Gx and Dell Servers

Data modeling: Visio, Toad Data Modeler and ERWin

Software development: Visual Basic, Visual Foxpro, C, NoSQL, PL/SQL and T-SQL

Operating Systems: Various Linux / UNIX platforms including OEL, RHL, Ubuntu, Sun Solaris and IBM AIX,Various MS-Windows Servers (from Rel. NT 4 through Windows Server 2012 R2 )

Virtualization: IBM LPARs, MS-Windows virtualization, VMware platform under Linux and Windows O/S,Oracle Solaris partitions

PROFESSIONAL EXPERIENCE:

Confidential

Senior Architect/DBA (Business Intelligence)

Responsibilities:

• Achieved significant cost saving by simplifying the systems architecture, implementing best practices for security and stabilized overall process of data movement from various partner sites to final destination of reporting for management.
• Reviewed existing business model and proposed various alternatives leading to improved business processes.
• Conducted extensive survey with all stakeholders and sites to understand: -
• Management hierarchy
• Responsibilities of various parties involved
• Mix of technologies and tools being utilized at partner sites and Confidential ’s facility
• Review technical challenges being faced by technical and management
• Communicate with all stake holders as and when what is needed; to bring everyone on the same page. So that everyone understand the expectations and role of involved parties as well as timelines about what will be done, by whom and when the deliverables are due.
• Work with vendors to get several ICD-9 to ICD-10 code conversions completed.
• Overcome several technical challenges being faced by all parties’ involved and devised acceptable Business Intelligence solutions for all stake holders.
• Brought data from various hospitals and surgical centers; into our Business Intelligence system for analysis and generate reports helping management in decision making. This required working with various hospitals and implement the Data Integration process between various sites (SQL Server based database servers) and our SQL Servers and Netezza appliance.
• Evaluate various technology platforms including IBM Big Insight, Netezza Macho, Microsoft Massive Parallel Server technology and, DataStax Enterprise ( components including Cassandra platforms in order to move RDBMS data into DataStax Cassandra).
• Introduced data provisioning and Data profiling.
• Redesigned and implemented the overall architecture of the Business Intelligence System including implementation of highly complex data integration processes
• Redesign and rebuild logical and physical data model(s)
• Re-purposed various servers
• Continue providing assistance/ guidance to various Confidential management associates in order to improve their team’s productivity and increase ROI.
• Provided guidance to team members in order to achieve organization goals.

Environment: SQL Server 2012 R2 (also: 2008 R2, 2005 and 2000), Windows Server 2012 R2, IBM Netezza Appliance (Asymmetric Massively Parallel Processing - Data warehouse server), InfoSphere Information Server, DataStax (DSE) Cassandra and IBM COGNOS TM1.

Confidential

Oracle Apps Database Administrator

Responsibilities:

• Provide production and non-production systems support for various business critical applications with worldwide user base; applications including Oracle EBS R12 and EBS 11i, Oracle Transport Management, Governance Risk Compliance Management, Configuration Control Governor and OBIEE.
• Assist developers/analysts in identifying and resolving various performance issues and resolving these issues by re-writing code efficiently, utilizing indexes, hints, partition tables/indexes, implementing optimized execution plan for queries, restructuring data files, database server kernel parameter, database parameters, re-organize database and rebuild indexes.
• Review and modify logical and physical data models as and when necessary.
• Upgrade the entire application implementation (application tier, web-tier and databases).
• Apply applications and database patches for all supported applications and databases.
• Clone various application environments (including apps tier, web tier and database tier).
• Change management: Work on migrations from development environment through production environment.
• Document procedures for work performed including system architecture, troubleshooting guides, password change procedures, cloning improvements, system startup and shutdown procedures.
• Work with developers, analysts, project managers, system / network/ security administrators, fellow DBA team members and vendors including Oracle support to resolve various applications and database issues.
• Manage database security utilizing best practices including utilization of roles and profiles. Change passwords on quarterly basis for key user accounts (Apps and database users).
• Implemented Incremental backup (Cumulative and Differential) for various databases.
• Communicate with user community while resolving issues related to them and also sending notifications/updates to them for schedule/un-schedule downtimes.

Environment: Oracle 11g R2 RAC, Oracle EBS R12/ 11i, OBIEE 11g, OEM 12c, Oracle Enterprise Linux 6, Sun Solaris 10, Toad, Oracle Exadata V2, SQL Server 2008 R2, Windows Server 2008 R2, Dell and HP servers.

Confidential

Senior Database Administrator

Responsibilities:

• Provided 24X7 production support for various enterprise wide business critical systems including Oracle / PeopleSoft CRM, FSCM and HCM.
• Provided development support following change management procedures.
• Worked with analysts, developers, project managers and department heads in order to provide maintenance and upgrades (go-live support).
• Upgraded apps and RDBMSs, applied patches and resolved technical issues including performance issues (PeopleSoft environments, SQL Server and Oracle databases).

Environment: PeopleSoft 8.x, Oracle 11g R2, Grid Control 11g, Oracle Enterprise Linux 5, Sun Solaris 10, SQL Server 2008 R2, SQL Server 2005, Windows Server 2008 EE, Toad, Dell and HP servers.

Confidential

Senior Database Administrator (SME)

Responsibilities:

• Provide subject matter expert services (Oracle DBA/ system architect).
• Utilize Best practices in order to design and implement new database servers (Oracle 11g).
• Improve system performance of database servers. I was able to improve the system performance that enabled HNTB to sell the product to various Army basis in USA.
• Work with developers and systems analysts to migrate data between various data sources (ETL). I was responsible to develop ETL scripts to import data based on given conditions in a given format and then load it into various target databases.
• Generate system health reports and resolve database installation and configuration issues.

Environment: Oracle 11g R2, Grid Control 11g, Windows Server 2008 EE, Quest Toad, Dell and HP servers.

Confidential

Senior Database Administrator (SME)

Responsibilities:

• Upgrade and migrate multiple SQL Server (release 2000 and 2005) databases from physical servers to SQL Server 2008 clusters hosting various business critical systems utilizing industry standards and best practices.

Confidential

Senior Database Administrator (SME)

Responsibilities:

• Provided production and development support and maintain database availability (24 x 7 x 365) of several hundred databases (OTLP and Decision Support Systems / Data warehouse systems) under AIX, Solaris, Linux and Windows environments.
• Upgraded various database servers to latest Oracle database releases.
• Backup/restore of databases utilizing RMAN, Tivoli and data-pump utilities.
• Refreshed non-production environments from production databases.
• Cloned databases as per requirements.
• Troubleshoot issues and work on performance tuning; utilize Oracle Grid Control and 3rd party tools including Toad, DBArtisan and several SQL scripts to review status of the database instances.
• Evaluated, tested and moved customized objects in databases (views, tables, indexes, synonyms, constraints and packages).

Environment: Oracle 11g/10g/9i, IBM AIX 6.1/5.3, Sun Solaris 10, Windows Vista, Toad, Tivoli, DBArtisan, IBM, HP, Dell and Sun Servers.

Confidential

Team Lead/ Senior Database Administrator

Responsibilities:

• Successfully merged 13 companies information systems into single trustable IS system for Monsanto.
• Studied and evaluated new technologies and implement the best possible solution based on requirements of the company as well as agreement between users of the final solution (hardware and software combined).
• Recommend, develop, document, and enforce best practices including the disaster recovery solution.
• Offered alternative solutions for various requirements to the top management.
• Work with team members in order to create project plan(s), get sign-off from related departments and implement project plans.
• Planned and conducted user acceptance tests and trainings.
• Worked with helpdesk team and work out plan about how to understand and assist users of the system in case if there is problem with the system and how to escalate the issue to further level.
• Designed, tested, implemented and managed systems for Utility management system, billing and various PeopleSoft Enterprise applications.
• Worked with Oracle’s PeopleSoft consulting services and Sun Microsystems teams in order to implement, maintain and upgrade:
• PeopleSoft Financial Supply Chain Management
• PeopleSoft Human Capital Management
• PeopleSoft Enterprise Management
• PeopleSoft Enterprise Portal
• Utilized Quest Data modeler for logical and physical data model (ERDs) as well as reverse engineer (ERDs) of databases in order to assist development team.
• Planed and implemented system upgrades (O/A, RDBMS, applications and storage).
• Prepared implementation plan and contingency plan for supported applications for moderate to large impact projects of the organization.
• Provided guidance to developers; in relation to PL/SQL (customizations, improvement of existing applications).
• Ensured databases were monitored proactively for optimal performance and the dba team acts quickly to mitigate performance issues.
• Prepare user defined functions, stored procedures, packages and triggers under Oracle and SQL Server environments.
• Utilized various in built functions (system, mathematical, string, metadata, security, cursor, configuration, system statistical) while writing new code and/or managing databases.
• Utilized SSIS (ETL) feature of SQL Server to transfer data between SQL Server and (replicate changes to Oracle databases and receive data from Oracle databases).
• Debugged issues and performance tuning utilizing various tools (PeopleSoft, Microsoft, Oracle and Quest). That included debugging PeopleCode, Application Engine processes, SQL statements, database components, configuration of web server, application server and batch servers etc.).
• Utilized Oracle Diagnostics, Grid control, Quest Performance Analysis, Quest Spotlight and O/S diagnostics software.
• Set and received notification for various events and jobs on database servers.

Environment: Oracle 11g/10g/9i (RAC, HAC and standalone servers), SQL Server 2008/2005/2000 , Windows Servers 2008 R2 and 2003 R2, Simpana, Quest Central, Toad Data Modeler, Oracle Grid Control Infrastructure, PeopleSoft FSCM 8.x, HCM 8.x, EPM 9, Enterprise Portal 9, AIX 6.1/5.3, Sun Solaris 10 & 9, VMWare, Sun Fire V890s and V1280s

Confidential

Team Lead, Senior DBA, Systems Analyst and Developer

Responsibilities:

• Lead the computerization of Common schedule of Rate (CSR) and Analysis of Common Schedule of Rates (ACSR). This product was designed to be used by every state's Government's Public Works Department and several thousand contracting companies all around the country.
• I was involved from gathering analysis, developed front-end app and built entire data structure for the application. These systems turned old contracts bidding system into computer based bill of materials (of several thousand labor and material items).
• Contractors could create and predict the cost of a hospital and other construction projects to be built over the time period with inflation and geographic variables in mind.
• Lead development of Material Management System: Prepare Bills of Material, Production Plans, and reports modules.
• Worked on multiple CRM, supply chain and data warehouse (business intelligence) projects at Microsoft.
• Utilized Visio and ERWin for data modeling software in order to prepare logical and physical data models (ERDs) as well as reverse engineer existing databases.
• Setup data replication between various SQL Server databases
• Developed and implemented data scrubbing engine utilizing stored procedure to clean the data first in the staging database after importing the data from various OLTP systems.
• Prepared hundreds of stored procedures, user defined functions (T-SQL) and utilized existing functions (date & time, mathematical, string, metadata and system).
• Lead development efforts and port data from various legacy systems into SQL Server database for Association of Secondary Teachers of Ireland and built data warehouse.
• Worked on various projects (complete software development life cycle). Developed ActiveX controls, front-end and middle tier components.
• Prepared new databases for various PeopleSoft application environments (dev, test, quality assurance, staging, training and development) in physical three tiers.
• Server installation (Windows Servers, SQL Server, Oracle, Oracle Enterprise Manager, Oracle Express Server etc.), 24 x 7 production support including:
• Apply application patches (for application from Cerner Millennium, PeopleSoft, PMSI, and Alliance).

Environment: SQL Server 2000/7, Oracle 9i/8i, Sun Solaris 8, Cerner Millennium, PACS, PMSI, Windows 2000, Windows NT 4, VMS, Visio, Visual Studio, Web Logic, Tuxedo, Erwin, and PeopleSoft 8.4/ 7.53