We provide IT Staff Augmentation Services!

Database Administration And Developer Resume

2.00/5 (Submit Your Rating)

Nashville Tn Database Administration And Developer Nashville, TN

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

Database administration and developer

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

Database administration and developer

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

Database administration and developer

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

Database administration and developer

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

Database administration and developer

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

Database administration and developer

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

Database administration and developer

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

Database administration and developer

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.

We'd love your feedback!