• Performed security administration across 200+ internal applications in multiple environments (PROD, TEST, STAGE and UNIT) using application specific tools.
• Implemented user authentication and authorization on multiple database platforms including Oracle, SQL Server, PostgreSQL, DB2 on Unix and Mainframe using platform specific database tools like SQL Developer, SQL Server Management Studio, pgAdmin following enterprise security policies.
• Administering security of LDAP groups and user accounts using application specific tools.
• Managing and administering Linux and Unix server access using Centrify and Super PuTTY
• Providing subject matter expertise and guidance to end users on enterprise security policies, standards, processes and procedures.
• Maintaining the Security knowledgebase and also updating the Operational Procedures.
• Active Directory groups and user administration using Remote Server Administration Tools
• Writing and updating SQL Scripts used for access management on Oracle and SQL Server databases
• Completing Security tasks and tracking them in HP Service Manager ticketing system.
• Responsible for ensuring compliance with security regulations and laws as well as preventing unauthorized access.
• Responsible for administering highly sensitive access to end users while ensuring compliance with policies and regulations.
• Troubleshooting and resolving all database access related issues
• Managing and administering security on the Mainframe using TSO and RACF commands
• Ensuring that users have the appropriate level of access they need to applications and data resources.
• Reviewing and processing applications and database Access Requests submitted via HP Service Manager while using the appropriate IAM Tools to provision or deprovision the access.

• Provisioning and deprovisioning database access across multiple database platforms including Oracle, Teradata, SQL Server, MySQL, Sybase and DB2.
• Working closely with customers and end users through emails, conference calls and IM in identifying and resolving database access related issues.
• Creating Active Directory groups, users, and adding users to Active Directory groups.
• Creating and managing Linux users, adding them to Linux groups.
• Following the company’s policy in provisioning Oracle and SQL Server database users using SQL Developer, SQL Server Management Studio and IBM Tivoli.
• Creating and submitting Pac2000 Problem Tickets and Work requests to responsible support groups for database access related issues.
• Provisioning and de-provisioning bulk user access via project requests.
• Executing Work Requests and working on assigned Problem Tickets.
• Training and bringing new team members up to speed with Oracle, Sybase, Teradata, MySQL and SQL Server database provisioning and deprovisioning as well as getting them used to the environment.
• Working in collaboration with the DBAs to identify and resolve database access issues.
• Identifying stale data within DSAM’s database inventory and submitting updates from other sources like the Triage tool and WDAI inventory.
• Administering and monitoring ART Workflow, manually generating reports and assigning ART tickets.
• Creating new ART form mockups for onboarding SybaseIQ and MySQL databases.
• Overseeing the Teradata database onboarding project for new Teradata environments.
• Troubleshooting failed IES requests and manually completing them.
• Rewriting and updating documentations with new processes and procedures on Access management on the various database platforms, including Oracle, Sybase, MySQL, Teradata and SQL Server.
• Updating and implementing new and existing policies to be followed by the team to mitigate risk and stay compliant.
• Modifying and executing Linux shell scripts to automate Sybase audit jobs and Sybase maintenance
• Writing Oracle and SQL Server SQL scripts for bulk access management.

Some tools used: AMS, Triage, ART, ACT, IBM Tivoli, SQL Developer, SSMS, Office Suite, sqlplus, BMC Remedy, IES, MySQL Workbench.
Database Platforms: Oracle, SQL Server, Sybase, DB2, Teradata, MySQL.

• Installation and Maintenance of Oracle 10g and 11g, on IBM-AIX, LINUX and Windows platforms.
• Utilized Grid Control to administer multi-node RAC database also managed redo and undo in the RAC environment. Load balancing of RAC instances.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export and Data pump utilities).
• Creating &Managing Database Structures, Storage Allocation, Table/Index segments, Constraints, Database Access, Roles and Privileges.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, Indexing and use of Hints, Stored outlines, Statistics for the same.
• Performance tuning and diagnosing DBMS and individual Production databases, organized various migration review meetings with the application team to discuss the migration strategy based on their requirements.
• Applied Patches on RAC, Standalone, Standby databases based on the requirements.
• Evaluated mix of backup and recovery methods based on organizational needs. Implemented, tested and documented various backup/recovery scenarios for knowledge base.
• SQL tuning using explain plan, tkprof.
• Installation, Configuration and Maintenance of RAC on Linux and Solaris using ASM and RAW devices and Oracle CRS, Stand by database.
• Upgrading development and production databases to Oracle 11g.
• Migrating from Oracle 10.2.0.4 on Solaris databases to Oracle 11.2.0.2 on Linux.
• Installed and applied various patches which include Critical Patch Update (CPU), Patch Set Update (PSU) and One-off patches using OPatch and runinstaller, also involved in upgrade of oracle database 10g to 11g.
• Experience with data movement using Oracle utilities like Export/Import, Data pump and SQL *Loader.
• Involved in Monitoring, Optimizing Oracle database for Performance Tuning & system/modules for Application Tuning using tools like AWR, ADDM, ASH, STATSPACK, TKPROF, EXPLAIN PLAN, SQL TRACE, and UTLBSTAT.
• Responsible for optimizing the queries and application tuning.
• Experience on working with data guard physical/logical standby databases.
• Used Data Pump for export and import. Wrote scripts for Backup of databases, maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
• Database Refreshing / Replication from production to testing using Exp/Imp.
• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports.
• Performed Table Partitioning, created Index Organized tables and Locally Managed Tablespaces.
• Monitored and provided weekly reports on the server’s memory, disk and CPU I/O using HP tools and UNIX command-line utilities.
• Planned and configured disk layout, mount points and capacity requirements for servers.
• Provided maintenance of user accounts, privileges, profiles and roles.
• Involved with OLTP relational databases system analysis, design, implementation and management.
• Upgrade/Migration of Databases from Oracle 10g to 11g, Cross platform migration from different platforms.
• Administered (11g RAC) environments adding and removing nodes to the cluster and handled performance tuning using AWR.
• Supported off-hour on call support for database related issues.
• Created logical and physical design installed and upgraded databases.
• Documented the Standard Processes for peers to follow.

Environment: IBM-AIX, Windows 2003/NT, Oracle 11g and 10g, RAC, TOAD, OEM, DATAGUARD, RMAN, Data Pump, Diagnostic and Tuning Advisors.

• Installation and Maintenance of Oracle 10g and 11g, on IBM-AIX, LINUX and Windows platforms.
• Utilized Grid Control to administer multi-node RAC database also managed redo and undo in the RAC environment. Load balancing of RAC instances.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export and Data pump utilities).
• Creating &Managing Database Structures, Storage Allocation, Table/Index segments, Constraints, Database Access, Roles and Privileges.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, Indexing and use of Hints, Stored outlines, Statistics for the same.
• Performance tuning and diagnosing DBMS and individual Production databases, organized various migration review meetings with the application team to discuss the migration strategy based on their requirements.
• Applied Patches on RAC, Standalone, Standby databases based on the requirements.
• Evaluated mix of backup and recovery methods based on organizational needs. Implemented, tested and documented various backup/recovery scenarios for knowledge base.
• SQL tuning using explain plan, tkprof.
• Installation, Configuration and Maintenance of RAC on Linux and Solaris using ASM and RAW devices and Oracle CRS, Stand by database.
• Upgrading development and production databases to Oracle 11g.
• Migrating from Oracle 10.2.0.4 on Solaris databases to Oracle 11.2.0.2 on Linux.
• Installed and applied various patches which include Critical Patch Update (CPU), Patch Set Update (PSU) and One-off patches using OPatch and runinstaller, also involved in upgrade of oracle database 10g to 11g.
• Experience with data movement using Oracle utilities like Export/Import, Data pump and SQL *Loader.
• Involved in Monitoring, Optimizing Oracle database for Performance Tuning & system/modules for Application Tuning using tools like AWR, ADDM, ASH, STATSPACK, TKPROF, EXPLAIN PLAN, SQL TRACE, and UTLBSTAT.
• Responsible for optimizing the queries and application tuning.
• Experience on working with data guard physical/logical standby databases.
• Used Data Pump for export and import. Wrote scripts for Backup of databases, maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
• Database Refreshing / Replication from production to testing using Exp/Imp.
• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports.
• Performed Table Partitioning, created Index Organized tables and Locally Managed Tablespaces.
• Monitored and provided weekly reports on the server’s memory, disk and CPU I/O using HP tools and UNIX command-line utilities.
• Planned and configured disk layout, mount points and capacity requirements for servers.
• Provided maintenance of user accounts, privileges, profiles and roles.
• Involved with OLTP relational databases system analysis, design, implementation and management.
• Upgrade/Migration of Databases from Oracle 10g to 11g, Cross platform migration from different platforms.
• Administered (11g RAC) environments adding and removing nodes to the cluster and handled performance tuning using AWR.
• Supported off-hour on call support for database related issues.
• Created logical and physical design installed and upgraded databases.
• Documented the Standard Processes for peers to follow.

Environment: IBM-AIX, Windows 2003/NT, Oracle 11g and 10g, RAC, TOAD, OEM, DATAGUARD, RMAN, Data Pump, Diagnostic and Tuning Advisors.