We provide IT Staff Augmentation Services!

Database Administrator Resume

Parsipanny, NJ

SUMMARY:

  • Over ten years of professional experience in Oracle Database Administration and over six years in Sql Server Administration and Informatica.
  • Extensively worked with database development writing stored procedures, functions, packages and database triggers using SQL & PL/SQL coding.
  • Good interaction with Business Analyst, Managers, Developers, QA and End Users.
  • Proficient in DBA activities such as Database Creation, Database Maintenance, Database Backup and Recovery, Database Tuning, Application Tuning, Security, Migration.
  • Extensive experience in design and Implementation of database backup and recovery.
  • Very good knowledge of Software Engineering and exposed to all phases of Software Development Life Cycle (SDLC).
  • Applying Oracle security patches.
  • Involved in regular data monitoring, data backup/recovery processes.
  • Duties involve regular maintenance, monitoring, performance analysis, trouble shooting, problem resolution, and user assistance, user testing.
  • Knowledge on Data warehousing concepts like OLAP Architecture, Star Schema, Snowflake Schema, Dimension Tables, Fact Tables.
  • Worked on different types of transformations like Expression, Filter, Aggregator, Rank, and Look Up, Update Strategy, Sequence Generator, and Joiner.
  • Possess strong analytical and problem solving skills coupled with very good communication and interpersonal skills.

TECHNICAL SKILLS:

Operating Systems: UNIX, Solaris and Linux, Windows 95/98/2000/NT/XP/2008

RDBMS: Oracle 8i, 9i, 10g,11g, MSSQL Server 2000/2005/2008

Front Ends: Forms 3.0/4.5, Visual Basic 3.0/4.0.

Database Tools: Oracle Enterprise Manager, SQL Navigator, TOAD, Erwin, DBArtisan, OEM 10g Grid Control,Tidal Enterprise Scheduler,MFT ( Managed File Transfer)ETL TOOLS: Informatica 8.1.1,Informatica 9.0

Reporting Tool: Cognos 7.0

PROFESSIONAL EXPERIENCE:

Confidential, Parsipanny, NJ

Database Administrator

Responsibilities:

  • Performed Installations, upgrades, monitor, performance tune and support operations in the Oracle and SQL Server environments.
  • Monitored Databases for Government Pricing/Rebate Systems, Supply Chain, Documentum, Web applications implemented on Liferay and Business Objects Applications.
  • Loading data in to the database using SQL*Loader , developed pl/sql scripts.
  • Performed logical backups using Export/ Import utilities.Refreshing databases from production to test/dev environments.
  • Working in a team to set up the in - house datawarehouse.
  • Proactive Measures -- Tablespace estimates, benchmarking of databases, health check scripts, cache hit ratio monitoring and space analysis using OEM Grid Control.
  • Built the Database Operations Guide and procces documents to install, create, upgrade databases.
  • Manage other database activities like Backups/Recovery/Security etc.
  • Developed solid test documentation and created and maintained comprehensive test plans and test cases to support UAT and QA Testing.
  • Invlolved in the team to set up the Sql Server 2005 clustred environment for all the enterprise application Databases
  • Worked with EDI Transaction Data Sets 852 and 867, Wholesaler Data,Customers Data etc.
  • Implementing backup strategies -- RMAN and User managed Backups. Involved in building a test server environmnt using RMAN Backup.
  • Applied patches and service packs to keep the database at current patch level.
  • User Management and Security in Oracle/SQL Server Databases.
  • Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
  • Extensively used SSMO, Query Analyzer, and SQL Server Profiler.
  • Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SSIS.
  • Experience in failover clustering, worked using the Windows Cluster administrator.
  • Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
  • Good knowledge in developing and designing reports through SSRS.
  • Involved in developing E-R diagrams, logical & physical data modeling, development and implementation of the system using ERWIN, relationship Diagrams.
  • Clone/Refresh of Production databases to Testing and environments.
  • Application tuning using Explain Plain, Tkprof and SQL Tracing.
  • Maintaining transaction logs and Maintainance Plans in Sql Server.
  • Provided technical assistance to vendors in development and implementation of packaged applications
  • Working closely with the business users, application teams to understand the requirements and converting them into project level technical capabilities.
  • Involved in writing shell scripts/Perl Scripts to extract data for performance, to automate database operations.

Environment: Windows 2000/2003/2008 , Unix, Red Hat Linux,Oracle 9i/10g/11g,SAN, RAC, SQL, PL/SQL, TOAD, Oracle 10g Grid Control, Veritas Netbackup, ERWIN, Enterprise manager for SqlServer, SCOM (Systems Configuration Operations Manager), Sql Server Clustering, Windows Cluster Administrator, Aqua Data Studio 6.0, Informatica8.1, Informatica 9.0, Tidal Enterprise Scheduler, MFT (Managed File Transfer)/VLTrader.

Confidential, Charlotte, NC

Database Administrator

Responsibilities:

  • Provided 24 by 7 on call support.
  • Installing & upgrading ORACLE database software.
  • Updating, migrating, and refreshing database environments.
  • Production Support of daily DBA sanity checks, space and health checks on Production and QA Databases.
  • Reorg of the Databases.
  • Monitoring memory, CPU utilization, disk utilization (I/O usage) and locks using OEM 10g Grid Control.
  • Monitoring Tablespaces, alerts and other Metrics using OEM ORACLE 10g Grid Control.
  • Involved in applying Oracle security patches to reach the Oracle standards using the OPATACH utility.
  • Supported changes for all the audit trails.
  • Application tuning using Explain Plan, TKPROF.
  • Involved in writing shell scripts to extract data for performance.
  • Created indexes, re-building indexes for performance improvement.
  • Created, maintained ORACLE Database Import/Export scripts
  • Granted DML privileges/roles for users, issuing quotas for tablespace/schema access.
  • Created Stored Procedures, Functions, and Packages using TOAD.
  • Using RMAN for backup and recovery methods

Environment: Sun Solaris, Oracle 9i/10g, SQL, PL/SQL, TOAD, Oracle Enterprise Manager, OEM 10g Grid Control.

Confidential, NYC, NY

Database Administrator

Responsibilities:

  • Performing evaluations of potential tools & utilities.
  • Installing and upgrading ORACLE databases.
  • Automating database tasks via scripting or through the use of tools.
  • Updating, migrating, and refreshing ORACLE database environments.
  • Configuring monitoring and proactively reviewing statistics for errors, capacity and performance issues.
  • Application tuning using Explain Plan, Utlbstat, Utlestat, Tkprof and SQL trace facilities.
  • Tuning and troubleshooting software & database performance issues.
  • Data modeling, normalization, de-normalization, physical database design, relational models for Several web-based applications.
  • Ensuring database recoverability within the constraints of any application, project and other requirements.
  • On-going SQL tuning using Explain Plan and SQL Trace
  • Support UAT and QA testing.
  • Involved in writing shell Scripts for Backup and recovery methods
  • ORACLE Database maintaining including backups, restores, imports, exports
  • Data migration, loading with SQL Loader
  • Providing input to and/or producing metrics reports.
  • Was a Production support DBA.
  • Responding quickly to requests; even if only acknowledging receipt, providing an estimated time frame and/or gathering additional information.
  • Producing and/or updating documentation and Standard Operating Procedures (SOPs).
  • Providing input regarding ORACLE database standards and best practices.
  • Advocating the upgrade of ORACLE database products to the latest standard versions.
  • Performing multiple tasks and adjusting to changing priorities and deadlines. Negotiating deadlines with customers and keeping them informed of changes to manage their expectations.
  • Working collaboratively with the project team and involving management only when necessary.

Environment: Sun Solaris 8, Oracle 9i/10g, SQL, PL/SQL, TOAD, Oracle Enterprise Manager, ERwin Data Modeler.

Confidential, New York City, NY

Database Administrator

Responsibilities:

  • Used Toad for Oracle to create Tables, Views, Synonyms and Stored Procedures.
  • Improved performance of existing Queries and Stored procedures.
  • Participated in database design sessions.
  • Written shell script to extract daily transactions from Oracle database into flat files.
  • Wrote stored procedures to insert data into archive database from production database and maintained archive database.
  • Developed interfaces to transfer data from different applications using Oracle SQL*Loader,PL/SQL procedures.
  • Worked on indexes on tables to create useful indexes and dropping some unnecessary indexes.
  • Monitored memory, CPU utilization, disk utilization (I/O usage), locks/deadlocks and runtime of queries.
  • Transformed and Loaded data from text files (from mainframe) to MS SQL Server 2000 database.
  • Installed, configured and administrated Oracle9i in the integration and production environment.
  • Applying Oracle security patches.
  • Extracted, transformed, and loaded data from Oracle database to Microsoft SQL Server 2000 database using ODBC and Data Transformation Services (DTS).

Environment: Oracle9i, Toad, Microsoft SQL Server 2000/2005, PL/SQL, Microsoft Data Transformation Services (DTS), Microsoft SQL Enterprise Manager, UNIX Shell Scripts, Sun Solaris, Windows XP

Confidential, NJ

Database Administrator

Responsibilities:

  • As a DBA responsible for installation, configuration, and setup various monitoring and support of more than 20 production, QA and development Database servers on 24/7 basis in banking environment.
  • Developed and implemented Database Security, Security Lockdown, Backup & Recovery strategies
  • Developed various TSQL, Stored Procedures, Triggers for Database monitoring
  • Extensively worked on Backup and Recovery, Sizing, Database Optimization, SQL tuning and code optimization
  • Experience in using ER-WIN
  • Extensively worked on Server Hardware configuration and hardware upgrades
  • Implemented automated scripts using WINBATCH for managing group of SQL Agent Services
  • Experience in configuring Alarm and Alerts using Perl script, SQL Mail.
  • Developed and implemented Business related Batch Job using Visual Basic
  • Setting up Business resumption databases using DTS, BCP, Replication, Log shipping
  • Experience in creating a SQL server Data warehouse and managing Cubes, Dimensions, Measures and handling MDX, ADO MD queries.
  • Handling ETL tools like Act Works, Sagest and performance monitoring tools like Patrol, I Watch
  • Developed an Infrastructure Database front-end using ASP, IIS, MS-SQL SERVER which contain Hardware/Software details of all Servers/Projects and linked the front-end to IBM Director Database.
  • Experience in Change control Environment involving diversified Group of peoples

Environment: MS SQL Server 7.0/2000, Oracle 9i, MS-Access, Windows NT v4.0, Windows 2000, ASP, VB, IIS, Sybase, Unix, MTS, R-Admin, IWATCH, Patrol, DB Artisan, Crystal Reports, Win Batch, IBM Director .

Confidential

Database Administrator

Responsibilities:

  • Created test database and its application tablespaces. Created admin users and granted the role to the users with high level security to protect the database from unauthorized access.
  • Implemented Index organized tables to improve the performance.
  • Tuning of INIT parameters to improve the performance during data loading.
  • Designed and mapping steps of daily and weekly ETL processes for reports.
  • Generating the Dataflow Diagrams and ER Diagrams Using Erwin,
  • Creating the Database Schema, converting VIEWS specific to database.
  • Creating roles and users
  • Applying Oracle security patches.
  • Providing input regarding database standards and best practices.
  • Advocating the upgrade of database products to the latest Confidential standard versions
  • Loading data from different sources to Target Data warehouse.
  • Using RMAN for backup and recovery methods.
  • Involved in writing Shell Scripts for Backup methods.
  • Performing multiple tasks and adjusting to changing priorities and deadlines. Negotiating deadlines with customers and keeping them informed of changes to manage their expectations.
  • Working collaboratively with the project team and involving management only when necessary.
  • Monitoring and performance tuning.
  • Recommend upgrades to software and hardware as it relates to the server and the client
  • Installation of patches and enhancements to both clients and servers
  • Participate in beta testing of new releases
  • Create/maintain system documentation.
  • Involved in ETL methods using Informatica.
  • Generating reports using Cognos.
  • Migrating Databases from Oracle 9i to MS-SQL Server 7.0/2000, IBM DB2 UDB8.1
  • Creating DB Links in Oracle for communicating with external databases.
  • Extracting data from different databases and maintaining.

Environment: Sun Solaris 9, Oracle 9i, SQL Server 2000, SQL, PL/SQL, Cognos, Informatica, TOAD, Oracle Enterprise Manager, ERwin Data Modeler.

Confidential

Database Administrator

Responsibilities:

  • Developed server side Perl Scripts for data collection and manipulation for the reports
  • Developed various stored procedures, triggers on MS SQL Server database
  • Created many TSQL batch scripts for backend work.
  • Design and developed DBI/DBD and DB Library connection Scripts for the data retrieval and data manipulation
  • Designed and developed many Perl modules and package
  • Design documents (Low & High Level Design, Design Level Document)
  • Developed many HTML pages for data presentation and collection
  • Participated in Unit/System testing
  • Took part in project documentation

Environment: Perl, Java, CGI, Html, JavaScript, MS SQL Server 2000, DBI/DBD, DB Library, Apache Web Server, HPUX, Windows NT

Hire Now