We provide IT Staff Augmentation Services!

Database Administrator / Data Architect Resume

Iowa, PanorA

PROFESSIONAL SUMMARY:

  • Has overall 19 years of rich and diverse experience in different industries and technologies and I have 7+ years of experience in United States as a Database Administrator/Data Architect.
  • Very good experience in Installation, configuration and maintenance of Oracle/SQL Server.
  • Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
  • Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
  • Very good T - SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands
  • Experience in Database backup and disaster recovery procedures.
  • Experience in Replication - Snapshot, Merge and Transactional.
  • Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.
  • Extensive experience with Oracle 9i Database, Replication, performance tuning, data warehousing, Materialized Views, backup and recovery, RMAN etc.
  • Expertise in Oracle version from 7.x - 10g
  • Expertise in MySQL version from 4.1, 4.0, 5.0, 5.1, 5.5 )\
  • Extensive experience in MySQL Configuration, Cluster Installation.
  • Created complex DTS Packages for Data Migration and Transformation. Experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2005/2000/7.0
  • Experience in MS SQL Server upgrades from 7.0 to MS SQL Server 2000 and from 2000 to MS SQL server 2005.
  • Sound Knowledge & Experience in MS SQL Server 2008/2012.
  • Worked in OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server.
  • Experience in SharePoint 2010 has an administrator
  • Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
  • Has Knowledge of Analysis Services & Reporting Services, SQL Server Clustering and Log Shipping
  • Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
  • Has the ability to work in a fast paced environment, Good team player and can work independently. Helped the database developers on technical issues.
  • I have responsibilities in designing document database of architecture. I build data scheme, tables, and procedures. I am a hard worker with compatible attitude.
  • Has experience in Microsoft Dynamics CRM 2013 installation &implementation.

TECHNICAL SKILLS:

Operating Systems: UNIX, Sun Solaris 5.8, Linux, windows 2000/2003/2008/2012/ NT/XP

Databases: Oracle 7/8/8i/9i/10g, MSSQL 2005/2008/2012 , MySQL( 4.x - 5.x)DB2, Sybase, Microsoft Access 2000

Languages: SQL, advanced PL/SQL, Java, XML, HTML, JDBC, Swing, Java BeansApplets, JavaScript, JSP, Java-Servlets, ColdFusion4.5

Oracle DBA tools: OEM, User-managed and RMAN Backup and RecoveryImport/Export utility, SQL*Loader, Oracle RAC, MySQL WorkBench 6.1 MySQL GUI Tools

SQL tuning: TKPROF, SQL Trace, STATSPACK, OEM

Case Tool: Designer 2000 v 1.3.2, Erwin Data Modeler 3.1/4.1.4

Reporting Tools: Business Objects XI, SSRS

ETL Tool: Informatica 7.1/6.2, Ascential Data Stage V 7.5 / 7.1/7.0 / 6.0 , SAP-BW 3.1SSIS, Erwin

Other Tools: Oracle Developer 2K Forms and Reports, Oracle Graphics, Oracle DiscovererMS Project 2000, SOX, MS Visio 2003, SQL PLUS, PL/SQL Knowledge ExpertTOAD, SQL Navigator, IQ Objects

Hardware: IBM e-Server, HP ProLiant ML 110, Dell 6650, Compaq Proliant ML 330/ DL380

PROFESSIONAL EXPERIENCE:

Confidential, Iowa, Panora

Database Administrator / Data Architect

Responsibilities:

  • Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
  • Design, document, and promote security "best practices", policies, standards and protocols.
  • Migrating application code and objects from development/test environments to production.
  • Experience working with large volumes of both structured and unstructured data.
  • Responsible for merging two different version of MySQL database into one.
  • Did MySQL Configuration, Clustering, Replication ( Master - Slave ) and updating patches on regular basis
  • Did Data Migration from MySQL to MSSQL, MySQL to PostgreSQL
  • Responsible for designing new DB structure and wrote complex procedures/function/ triggers in MySQL.
  • Did a major role in cleansing MySQL data.
  • Working with development and systems teams to perform application and database tuning.
  • In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development
  • Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
  • Setup and maintenance of appropriate database and application monitoring.
  • Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
  • Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.
  • Evaluating data modeling, database administration, and database backup and recovery tools and make recommendations.
  • Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
  • Responsible to Monitor and troubleshooting Log Shipping.
  • Review of physical and logical database design; Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.
  • Create processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle.
  • Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
  • Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
  • Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005/2008/2012 .
  • Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
  • Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
  • Used Policy Based Administration feature (SQL Server 2008).
  • Worked With 'Insert' commands to programmatically INSERT data if it does not exist or UPDATE the data if it does all in 1 set of logic (SQL Server 2008).
  • Checking Database Health by using DBCC Commands and DMVS
  • Monitored and modified Performance using execution plans and Index tuning.
  • Prepared Documentation for the Disaster Recovery plan
  • Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
  • Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
  • Sound Knowledge and experience in SharePoint 2010. Administration functions including deploying code solutions (.wsp), PowerShell scripts, server optimization, server management, term store maintenance, taxonomy, content deployment, web and service applications in Central Administration
  • Responsible routine DBA jobs like Backups and Restores.
  • Good experience in data modeling and Metadata services.

Environment: MSSQL 2005/2008/2012 , T-SQL, SSIS, SSRS, SSAS, Erwin, SQL Profiler, Replication, Log shipping, Mirroring, Clustering, Windows XP/2000 and Windows 2003/2008/2012 Server, PostgreSQL, SharePoint 2010, MySQL (4.x, 5.x), SQL Yog, Windows Terminal Services Client, VPN, Delphi 7.0, Ruby On Rails, MySQL Workbench 6.1, MySQL GUI

Confidential, Chicago, IL

Database Administrator / Data Architect

Responsibilities:

  • Designed, implemented and documented oracle Data Guard physical and logical standby Database disaster recovery solution.
  • Maintain high availability of databases for 24/7 global operation using Oracle RAC Databases on Linux operating system
  • Involved in Implementation and configuration of OEM, Oracle Management Server for Maintenance and monitoring.
  • Performing Partial, Complete and Metadata Exports & Imports.
  • Production and development for oracle 9i (9.2.0.5) database administration activities.
  • Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
  • Tuned SQL queries using TKPROF and EXPLAIN Plan
  • Created and customized UNIX shell scripts for automating regular maintenance and batch jobs.
  • Prepared the weekly and monthly database health report for Confidential oracle 9i database.
  • Actively involved in monitoring the lock processes, releasing locks in case of resource Blockage and gathering statistics.
  • Involved in understanding the scope of the application, present schema, data model and defining relationship within and between groups of data.
  • Involved in developing the process for extracting, cleansing, transforming and loading the data into a staging area.
  • Unit tested various scenarios to ensure that the job design and developments within the jobs meet the requirements.
  • Taken good initiative in participating the requirement meeting with the Business and System Analysts and gathering information with an ETL and Business Perspective.
  • Worked in par with the documentation procedures and ETL Standards within the company so that the jobs designed and developed are in pace with the future enhancements.
  • Done the DB2 partitioning (DPF)
  • Used Quest TOAD to tune query performance.
  • Did data migration from Oracle to DB2
  • Involved in Data Migration from Legacy application to Product application by using SQL * Loader.
  • Responsible for Creation of new oracle user, and do the import and export of the oracle Database dump.
  • Writing PL/SQL Procedures, functions and Data base triggers.

Environment: Dell 6650, Red Hat Linux 2.0/ 3.0, Oracle 8.1.7.4/ 9.2.0.4/9.2.05/10 gMSSQL 2005/2008, DB2, Windows XP/2000, DB2, SQL * plus, Shell scripts, OEM, PL/SQL, Vi- editor, ER Win Data Modeler, Ascential Data Stage 7.5, Business Objects XI, Oracle 10 g, Aqua Data Studio 4.7.2, PVCS Tracker 6.0.

Confidential

Database Administrator / IT Architect

Responsibilities:

  • Responsible for System Design, Analyze by using Erwin Data Modeler.
  • Responsible for creating and maintenance of Data base and Data base objects by using Erwin Data Modeler.
  • Responsible for supporting development team in implementing database and code changes. Performed recovery / refreshing of development and QA environments as and when needed.
  • Responsible for assessing, deploying and tracking changes to the development/ QA/ Stage and production environments.
  • Installation of Oracle 10g, Creation of Oracle Users, Creating and Managing Oracle Table spaces, Re-Indexing.
  • Data Migration from One Oracle Application User (legacy system) to another Oracle Application User.
  • Done table partitioning using DB2 partitioning features.
  • SQL, PL/SQL tuning, performance tuning for overall performance. Introducing architectural improvement to eliminate performance bottlenecks.
  • Responsible for developing and testing SQL, PL/SQL stored procedures, functions and Data base Triggers.
  • Implementation and configuration of OEM, Oracle management server, for maintenance and monitoring

Environment: Windows 2000 servers, Erwin Data Modeler, Red Hat Linux 2.4.18, Oracle (9i/ 10g), DB2, Citrix, OEM, SQL Navigator, TOAD, SQL Plus, Windows Terminal Services Client, Oracle Developer/2000 (Forms 6i, Reports 6i), Oracle Discoverer.

Confidential

Database Administrator / Data Architect

Responsibilities:

  • Experienced in Oracle database installation, capacity planning, RAID Configuration, Physical and logical database design, upgrade, patches, monitoring database and OS (Windows 2000) performance
  • Installed Oracle 8.1.7.0.1, applied patch set 8.1.7.4 and upgraded the databases to 9.2.0.4
  • Infrastructure Setup and Database implementation which include design, installation,
  • Creation, backup and recovery procedures, RAID Configuration plan, testing, Production-rollout and documentation.
  • Performing Partial, Complete and Metadata Exports & Imports.
  • Database monitoring for deadlocked process and maintaining logs/Backups using Import/Export Utilities.
  • Automating processes, scheduling jobs per user requirements. Logical and Physical Modeling.
  • Writing scripts for monitoring the database, Configuring SQL* Net, Integrating multiple application databases.
  • Performed Hardware and Software requirements analysis and proposed project plan for System upgrade to 9.2.0.5 with standby database.
  • Supporting the junior DBA’s various routine DBA tasks, PL/SQL best practices and Database performance tuning practices.
  • Responsible for developing and testing SQL, PL/SQL stored procedures, functions and Data base Triggers.
  • Implementation and configuration of OEM, Oracle management server, for maintenance and monitoring.
  • Tuned SQL queries using TKPROF and EXPLAIN Plan, Performed TSPITR using
  • RMAN by creating Auxiliary Database.

Environment: Windows 2000 servers, Erwin Data Modeler, Oracle 8.1.7.4, Oracle Developer/2000(Forms6i, Reports6i), Oracle Discoverer, SQL PLUS, Toad, SQL Navigator, Citrix, Remote Desktop Connection.

Confidential

Database Administrator / Data Architect

Responsibilities:

  • Done the Pre-sales activity of ORION Freight Forwarding Application
  • Implemented the ORION Freight Forwarding Application, ORION Trading Application and Interfaced with Legacy Accounting Application.
  • Installed Oracle 8.1.7.0.1, applied patch set 8.1.7.4 and upgraded the databases to 9.2.0.4
  • Completed - Infrastructure Setup and Database implementation which include design, installation, creation, backup and recovery procedures, RAID Configuration plan, testing, production-rollout and documentation.
  • Performed Hardware and Software requirements analysis and proposed project plan for system upgrade to 9.2.0.5 with standby database.
  • Design, implement the BOE and 3PL Modules as per the Business Requirement.
  • Implementation and configuration of OEM, Oracle management server, for maintenance and monitoring.

Environment: Dell 6650, Windows 2000, Oracle (9.2.0.4, 8.1.7.4), Oracle 9i (9.2.0.5), Oracle Developer/2000(Forms6i, Reports6i), Oracle Discoverer, SQL*Plus, TOAD, SQL Navigator, Citrix, Remote Desktop Connection, PL/SQL Knowledge Expert.

Confidential

Database Administrator

Responsibilities:

  • Involved in the Study and Implementation of Container Control, Import, and Export Modules of Shipping System.
  • Preparation of Business Solution Mapping document, Functional & Technical Specification Document.
  • Supporting the Development Team for the development of Container Control, Import and Export Modules
  • Involved in Installation of Oracle 8i/9i
  • Presented Existing Shipping Application to the Client.

Environment: Windows 2000 Professional, Oracle 8i/9i, Oracle Developer/2000(Forms6i, Reports6i), Oracle Discoverer, TOAD, SQL Plus, SQL Navigator, Citrix.

Confidential

Database Administrator / Data Architect

Responsibilities:

  • Responsible for Design a data base and data base objects by using case tool - Designer 2000
  • Implemented the ERP application across 35 locations in India.
  • The Shipping Management System is developed as per the Client Requirement and is developed for one of the Major Shipping Line MSC, China shipping, TSL
  • This system will provide all the information related to the Shipping Agencies.
  • This System consists of the following Modules namely System Admin, Capital, Documentation, Container Tracking System, Voyage Accounting, Customer Management System, Tariff Definition, User Management System and various Modules related to the transactions can be created in Static Masters
  • Necessary Reports are created for the above developed modules using strong oracle report tools like Reports 6i, Discoverer.
  • Study the EDI Structures based on that prepare a detailed level functional specification document.
  • Having sound knowledge in Port system and done the interface with port system & AFSYS
  • Involved in System Analysis & Design on Interaction with Clients, Screen Designing, Backend Procedures, Database Maintenance, and Creation of Forms and Report
  • Involved in Maintenance of Application server and Web server

Environment: Oracle 8i, Windows 2000, SQL PLUS, SQL Navigator, Oracle Developer/2000(Forms 6i, Reports 6i), Oracle Discoverer, Oracle Graphics, Citrix, Remote Desktop Connection, FTP Server, VNC Server.

Confidential

Database Adminstrator / Data Architect

Responsibilities:

  • Primarily involved in analysis & design, screen designing, backend procedures, database maintenance, and creation of forms and reports
  • Involved in the developing reports for the above by using the strong oracle reports tools like Reports 6i, Oracle Graphics and Oracle Discoverer.
  • Installed the OS with patch and also installed the Oracle 8i.
  • Installed the developer 2000 in all the client’s (user’s) Pc’s and Involved in Onsite development has done as per clients requirement.

Environment: Oracle 8i, Windows XP, Windows 2000 Professional, Oracle Developer/2000(Forms 6i, Reports 6i), Oracle Discoverer, Oracle Discoverer, FTP Server, Citrix, SQL PLUS, SQL Navigator .

Confidential

Junior Database Administrator

Responsibilities:

  • Involved in Implementation of Oracle Financials Modules.
  • The Implementation of the module includes, HRMS, GL, AR AP, apart from that involved in the customization of Payroll, CM, OSA, Card System, and Utilities.
  • Involved in database maintenance like management of rollback segments included the estimation of the optimal size and decreasing the rollback segment, done performance tuning by creating clusters and indexes.
  • Effectively managed the available space by changing the storage and space management parameters, conversion of non oracle data into oracle data using SOL Loader, Optimizing the Query and choosing the right access, Backend procedures, and Creation of Forms and reports.

Environment: Windows NT, Windows 95, Oracle Application 11i, Oracle Developer/2000(Forms 6i, Reports 6i), SQL PLUS, SQL Navigator, PL/SQL Knowledge Expert.

Confidential

Junior Database Administrator

Responsibilities:

  • Involved in writing procedures based on Client’s requirements and providing technical support for the Clients, Forms and Reports, and Backend.
  • Involved in the development of oracle forms and oracle reports.
  • Developed more than 45 oracle reports and 23 forms in Onsite.
  • Design a Sales review module in client place and implemented the same as per clients requirement

Environment: Windows NT 4.0, Windows 95/98, Oracle 7.3.4 - 8i, Oracle Developer/2000(Forms 4.5, Reports 2.5), SQL PLUS, SQL Navigator.

Hire Now