We provide IT Staff Augmentation Services!

Sql & Oracle Server Database Administrator/migration Specialist Resume

PROFESSIONAL SUMMARY:

  • 7 years of IT experience in Database Administration, Design Development and Support of MS SQL Server 2012/2008R2/2005/2000 in Production/Oracle Databases 10g/11g/12c, Test, Development and Cluster Server Environments.
  • Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2000 and SQL Server 2005/2008/2012 , Oracle Database 10g/11g/12c. Experience in Disaster Recovery Planning, Execution and Testing at remote side.
  • Experience in using SQL Server/Oracle Tools like DTS, Import/Export Wizard, SQL Server Enterprise Manager/OEM, SQL Profiler and SQL Query Analyzer.
  • Migration experience from MS SQL Server 2000 to MS SQL Server 2005/2008, MS SQL Server 2005 to MS SQL Server 2008 and Oracle 11g to 12c. Provided expertise in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/ OLAP technologies.
  • Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them).
  • Master in performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration and synchronization.
  • Extensive use of DTS/SSIS in SQL Server, Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, Managing server and clients.
  • Experience in implementing high availability using Log shipping, and knowledge of DB mirroring in SQL Server 2005 and Oracle Databases.
  • Experience with IIS (Internet Information Services) 5.0/6.0.
  • Experience on high availability SQL Server/Oracle solutions, including Replication Models (Snapshot/Transactional) and SQL Server clustering (Active - Active, Active-Passive). Experience in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2000/2005.
  • Experience in using SSIS (SQL Server Integration Services) for data extraction, transformation and loading across different databases like Oracle, MS Access and flat files using tools like Import and Export Wizard, Data pump, Package Installation and SSIS Package Designer.
  • Experience in designing/generating/using/deploying Visual Studio 2005 Business Intelligence Reports, SQL Server 2005 Reporting Services (SSRS), Crystal Reports.
  • Worked on disaster recovery, Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, Cold and Hot backup, Full backup, Incremental, Cumulative backup and implementing backup and recovery strategies.
  • Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
  • Installation and Administration of Oracle Physical Standby Database for single and multiple instances (RAC) to achieve high availability and DR solution (DATA GUARD and GOLDEN GATE). Experienced in applying oracle patchset, Patches, Critical Patch Update (CPU)/PatchSet Update (PSU) and One-off Patches using OPatch and run Installer.
  • Demonstrates strong analytic and problem solving skills .
  • Skilled in reducing costs/driving process improvements with a strong background and proficiency in Database design, analysis, data security and integrity.
  • Experience using tuning tools like TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR Terminal Emulation Putty, Telnet, FTP, TOAD Ticketing Tools BMC Remedy.
  • Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player.
  • Worked proactively and gave 24/7 on-call production support and Weekend support for maintenance and server level patching.
  • Good analytical and problem solving skills with ability to work independently and in a team environment.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2003, Windows 2000 Server/ Advanced Server, Windows 98/XP/Professional

Database Tools: Profiler, DTS, Management Studio/Enterprise Manager, Query Analyzer, SSIS, Talend Studio, SQL*Plus, Toad

Web Technologies: XML, HTML, VBScript

GUI Tools: Visual Studio (VB), Visual Studio2005/2003, RACOEM Grid Control, SQL* Loader, ASM, SQL Server, Export/ImportRMAN, NETCA, DBCA, TOAD, Exadata, Patch Management, SQLNET

ODBC, Export/Import, Data pump, Data: Guard, Erwin, Log-minerMS Visio, VERITAS Net Backup, BMC remedy, VMware, Crontab.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR Terminal Emulation Putty, Telnet, FTP, TOAD Ticketing Tools BMC Remedy, GIRA, Service Now, HP Quality Center

Languages: VB 6.0, VB.Net, T-SQL, SQL, PL/SQL, UNIX Shell Scripting

Web Server: Internet Information Server

Databases: SQL Server 2012/2008R 2/2008/2005/2000 , MS SQL, Oracle 9i.10g, 11g

Reporting Tools: Business Objects, Crystal Reports OLAP Tools SQL Server Reporting Server 2008/2005, SSIS (as ETL)

Third Party Tools: Lite speed, Erwin, Talend, Oracle Data Integrator.

PROFESSIONAL EXPERIENCE:

Confidential

SQL & Oracle Server Database Administrator/Migration Specialist

Responsibilities:

  • Migration of databases from 11g to 12c using export/import and data pump export/import utilities, scripting and AWS infrastructure tools. ETL scripting for migration.
  • Tuning performance using Advisors, AWR, ADDM, SQL tuning etc.
  • Configured and maintained data loads in huge Data warehousing systems using the Information Power Center ETL tool.
  • Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
  • Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine tuning Stored Procedures).
  • Data migration using DTS services across different databases like Oracle, MS access & flat files. Contacted various users in gathering the requirements and documented the necessary changes. Analyzed various backup compression tools available and made the recommendations.
  • Created necessary templates for various requirements gathering and documentation.
  • Maintained high availability of databases using Database Mirroring and Log Shipping.
  • Experience in Oracle Grid Infrastructure (ASM file system and RAC Clusterware).
  • Used third party tool, Lite Speed to speed up backup operations.
  • Created and maintained logical/physical data structures.
  • Detecting and diagnosing production system performance problem by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
  • Developed both database and OS-level security policies for data protection and having good experience in Working with Oracle security, Transparent Data Encryption, Oracle Wallet Management and Oracle Identity management.
  • Creating views and stored procedures and optimizing them as required by front-end developers for easier implementation on web pages.
  • Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
  • Application and Production support 24/7.

Environment: Windows 2000/2003, MS SQL Server 2000/ 2005/2008/2012 , Oracle Data Integrator, Talend, T-SQL, Oracle 10g/11g/12c, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0., TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR Terminal Emulation Putty, Telnet, FTP, TOAD Ticketing Tools BMC Remedy.

Confidential, Washington, DC

Database Administrator SQL & Oracle databases

Responsibilities:

  • Cloned 10g and 11g databases using RMAN replication.
  • Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application.
  • Tuning performance using Advisors, AWR, ADDM, SQL tuning etc.
  • Experience migration/consolidation of databases using Oracle 12c multitenant.
  • Planned disaster recovery scenarios with different recovery procedures and methods like Data Guard & Standby Database.
  • Detecting and diagnosing production system performance problem by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
  • Developed both database and OS-level security policies for data protection and having good experience in Working with Oracle security, Transparent Data Encryption, Oracle Wallet Management and Oracle Identity management.
  • Controlled user access rights, and managed data security.
  • Traced long running queries and deadlocks using SQL Profiler.
  • Experience in Oracle Grid Infrastructure (ASM file system and RAC Clusterware).
  • OBIEE 11g Proactive detection and Alerts.
  • Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
  • Black-out Administration.

Environment: Windows 2000/2003, MS SQL Server 2000/2005/2008 , Oracle 11g, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0., TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR Terminal Emulation Putty, Telnet, FTP, TOAD Ticketing Tools BMC Remedy.

Confidential, Washington, DC

Database Administrator

Responsibilities:

  • Utilized Grid Control to administer multi-node RAC database also managed redo and undo in the RAC environment. Load balancing of RAC instances.
  • Database Refreshing / Replication from production to testing using data pump.
  • 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.
  • Make modifications/and add new MDX queries to cubes.
  • Installed SQL server and implemented resource utilization on the server.
  • Converted many DTS packages to SSIS packages during the up gradation of the servers.
  • Involved with OLTP/OLAP relational databases system analysis, design, implementation and management.
  • Used Data Pump for export and import. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
  • Upgrade/Migration of Databases from Oracle 9i to 10g, Cross platform migration from different platforms.

Environment: Windows 2000/2003, MS SQL Server 2000/2005, Oracle 10g/11g, T-SQL, Red Hat Linux, TOAD, RMAN, OEM, Oracle Data Integrator, Sql Loader.

Confidential, Bensenville, IL

Junior Oracle Database Administrator

Responsibilities:

  • Installation and configuration of Oracle database 9i (9.2.0.4), 10g (10.2.0.1) on various OS platforms like HP-UX, Linux, and Windows NT, 2000
  • Controlled and monitored user access to the database. Optimized the performance of the database. Tuned SGA data dictionary and set database parameters
  • Reorganized data files, identified and eliminated contention factors like I/O, buffers and locks
  • Allocated separate rollback segments for Batch processing jobs in other to speed up processing.
  • Reorganized data files, identification and elimination of contention factors like I/O, buffers and locks.
  • Worked with Oracle Diagnostics tools such as Explain Plan, SQL Trace, TKPROF used to analyze timing and execution plans for SQL query to tune SQL statements.

Environment: HP-UX, Windows, Linux/Unix, Oracle 10g, SQL, PL/SQL, SQL plus

Hire Now