SUMMARY:

• 11+ years of experience in database administration and developer with demonstrated expertise in installation, configuration of Oracle (Oracle 9i,10g & 11gr2, 12C) and SQL Server 2008/2012/2014 databases in Clustered and Non - Clustered environments.
• Extensive experience in Installations, Upgrades, Migration, implementation, performance tuning, backup, recovery and daily monitoring of the ORACLE 10g/11g/12c and sql server 2008R2 and 2012 databases on 24x7 Environment with shared Storage and Rackspace environment.
• Trained on Installation and configuration of 10g, 11g &12c RAC Databases upto 2 nodes with OCFS and ASM and SQL SERVER 2012 and 2008R2 installation on standalone and Windows cluster environment.
• Working experience in Performance Tuning of SQL/PLSQL queries, shell scripting.
• MS SQL Server database administration strengths include: installation, configuration, database design, database creation, and backup, recovery, monitoring growth, database replication, log shipping, application support, performance tuning, security administration, user administration, day-to-day support and maintenance.
• Proficient with SQL server management studio, Enterprise manager, SQL Query analyzer, scheduling jobs with SQL server agent and restoring databases.
• Supported and delivered demanding and dynamic businesses under pressure
• Understanding of ITIL (Information Technology Infrastructure Library) Foundation course.
• Adept in end-to-end development of software products from requirement analysis to designing, coding, documentation and implementation.
• Tools proficient with PL/SQL Developer, Toad, Remedy, Pitney Bowes, HPSM.
• Possess Technical knowledge in SQL, PL SQL, Sys Admin, Shell Scripting, DBA, and Report Designing.
• An effective communicator with excellent relationship building & interpersonal skills. Strong analytical, problem solving & organizational abilities.
• Possess a flexible & detail oriented attitude.

PROFESSIONAL EXPERIENCE:

Confidential, Nashville, TN

Responsibilities:

• Upgrade production and non-production, Standby and Golden Gate 12c, oracle12c,SQL Server 2014 databases with latest Security Patches.
• ODA X6-2 newly server build and patching.
• Cross Platform Migration from HP-UNIX to ODA X6-2 servers.
• Golden gate replication from Oracle to SQL server.
• Code review before implement on production database.
• Tune SQL and PL/SQL object which consume lot of resources like CPU and MEMORY.
• Monitoring database with the help OEM cloud control 12C.
• Creating new users and manage roles and privileges
• Prepare Database Health Check list on Daily Basis.
• Check RMAN Backup and Export Backup on daily Basis.
• Golden Gate 12c administration and day to day support work
• Standby sync up with the help of RMAN backup or day to day administrations. DR Testing to
• TAPE Backup testing every quarter.
• Creating maintence plans and jobs in SQL server for full backup, log backup and day to day operational activity.
• Creating new users and manage roles and privileges.
• SQL SERVER Log shipping monitoring and configuration to fulfill reporting requirement
• Continuously Monitor the System response time and detect for any bottlenecks along with possible solutions.

Confidential

Responsibilities:

• Installation and upgrade Oracle 11gR2 database and sql server 2012/2008 R2 on windows cluster and non-cluster on RACKSPACE (Cloud) environment.
• Designing DR solutions and reporting solutions for SQL SERVER database on Rackspace Environment (Cloud environment).
• Upgrade Dev, UAT and Production database with latest patch.
• Upgrade Oracle 11.2.0.3 to 11.2.0.4 patch.
• Creating database, create role, create policy for Production/Quality/Development environment.
• Migration planning and migration database objects from sql server database to oracle database.
• Database object migration from SQL SERVER to ORACLE (like Procedure, Package, Function, trigger etc.)
• Prepare design document (LLD, HLD, Test document, Migration Strategy Plan, Sop’s etc.)
• Monitoring Users, table space, data files and rollback segments.
• Automate all dba manual tasks with the help of Crone job and shell script.
• Creating maintance plans and job in sql server for full backup, log backup and day to day operational activity.
• Creating new users and manage roles and privileges.
• SQL SERVER Log shipping monitoring and configuration to fulfill reporting requirement.
• Continuously Monitor the System response time and detect for any bottlenecks along with possible solutions.

Confidential

Responsibilities:

• Technical lead, Architect for Data Center operation team.
• Lead/Participate in Joint Application Design sessions with the client and help the Business Analyst with requirement gathering and requirement analysis.
• Help the support team resolve problems.
• Conduct design and code reviews.
• Created SOP and documentation.
• Mentor technical team and advise clients on processes and technologies.
• Evaluate solutions and technologies. Maintain SLA, client communication and management reports.
• Provide daily and weekly reporting for client communication.

Confidential

Technology lead, Architect

Responsibilities:

• Deliver high quality, scalable design.
• Migration planning and execution plan from Temp Data Center to Permanent Data Center.
• Migration planning and implementation Oracle Database from VMware to OVM.
• Installation and upgrade Oracle 11gR2 database on Oracle Linux 6.5 platform and sql server 2012/2008 R2 on windows cluster and non-cluster environment,
• Upgrade Dev, UAT and Production database with latest patch.
• Upgrade Oracle 11.2.0.3 to 11.2.0.4 patch.
• Creating database, create role, create policy for Production/Quality/Development environment.
• Prepare design document (LLD,HLD, Test document, Migration Strategy Plan etc.)
• Monitoring Users, table space, data files and rollback segments.
• Automate all dba manual tasks with the help of Crone job and shell script.
• Creating maintance plans and job in sql server for full backup, log backup and day to day operational activity.
• Creating new users and manage roles and privileges.
• SQL SERVER Log shipping monitoring and configuration to fulfill reporting requirement.
• Continuously Monitor the System response time and detect for any bottlenecks along with possible solutions.

Confidential

Responsibilities:

• Installation and upgrade 10gR2 database on Solaris 10 platform,
• Tune sql and pl/sql object which consume lot of resources like CPU and MEMORY.
• Upgrade Dev, UAT and Production database.
• Monitoring Users, table space, rollback segments and tuning SGA.
• Taking Hot/Cold Backups of database.
• Creating new users and manage roles and privileges
• Prepare Database Health Check list on Daily Basis.
• Check RMAN Backup on daily Basis.
• Continuously Monitor the System response time and detect for any bottlenecks along with possible solutions.

Confidential

Responsibilities:

• Development and Delivery responsibility of CRM to fulfill Residential, SoHo and Enterprise customer segment of Atheeb by using Wimax Technology.
• Supporting prepaid and postpaid customer segment.
• Providing Support for DBA, system Admin, configuration of CRM related activities.
• Leading team to support following critical business flow.
• Price plan configuration (like: Base Plan, Renewal Plans, Speed Renewal Plans) in CRM system.
• Discount configuration for Business and Residential customer.
• Telephone Number booking system.
• SIMHA, SADAD and Credit Card integration support.
• Business rule configuration in CRM system.
• CPE Stock increment and decrement.
• Order Management and order tracking system.
• Order dependency check.
• Account id and subscriber id creation.
• Maintain Wimax device information like (CPE, Dongle, Softda)
• CDR reconciliation between interconnect and BRM systems
• Code review before implement on production system.
• Working on Remedy to resolve incident, Problem incident creation, Change release,
• Prepare Root Cause Analysis for problem incident
• Creating new users and manage roles and privileges.
• Prepare Database Health Check list on Daily Basis.
• Continuously Monitor the System response time and detect for any bottlenecks along with possible solutions.
• Report designing with help of Pitney Bose application (Sagent Designer, Sagent Automation)
• Provide reports and (adhoc request) data to finance team.

Confidential

Responsibilities:

• Installation of oracle software on different platform.
• Code review before implement on production system.
• Tune sql and pl/sql object which consume lot of resources like CPU and MEMORY.
• Creating database for Production/Quality/Development
• Monitoring Users, table space, rollback segments and tuning SGA.
• Taking Hot/Cold Backups of database.
• Creating new users and manage roles and privileges
• Prepare Database Health Check list on Daily Basis.
• Check RMAN Backup and Export Backup on daily Basis.
• Coordinating with Onsite team members
• Continuously Monitor the System response time and detect for any bottlenecks along with possible solutions.

Confidential

Responsibilities:

• Discussion with different stack holder.
• Requirement gathering from business to fulfill business needs.
• Database designing as per business logic and application requirement.
• Created database and configured parameters and backups for new database bases.
• Installation oracle software and database on different environments.
• Creating security policies, designing database objects.
• Manage, monitor and resolve the problems related to the growth of databases and give appropriate recommendations to the users

Confidential

Responsibilities:

• Installed, upgraded and applied patches to oracle software.
• Tuned Application and different SQL queries and code.
• Partitions the existing tables and rebuilding the indexes.
• Writing procedure, function, package and different type of trigger on tables.
• Created DBA maintenance jobs like index rebuild, Table reorganizing, gather statistics etc.
• Sizing the SGA (Database buffer cache, Redo log buffer, Shared pool) according to the requirement
• Manage, monitor and resolve the problems related to the growth of databases and give appropriate recommendations to the users
• Worked on archiving projects.
• Configure user defined alert as per requirement.
• Created database and configured parameters and backups for new database base.
• Refreshed database using hot/cold backup, RMAN and Import/Export utility.
• Performed recovery.
• Migrated and upgraded database to upper version.
• Worked with development team and designed data model for Insurance modules.
• Worked on data modeling of data warehouse modules (projects).
• Refresh Development and UAT Server from Production Server.