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 developerResponsibilities:
- 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 developerResponsibilities:
- 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 developerResponsibilities:
- 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 developerResponsibilities:
- 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 developerResponsibilities:
- 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 developerResponsibilities:
- 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 developerResponsibilities:
- 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 developerResponsibilities:
- 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.