We provide IT Staff Augmentation Services!

Database Architect Resume Profile

PROFESSIONA SUMMARY

  • Wel Experienced senior Application DBA / Data Architect/ Data Modeler having more than 15 years of experience in IT and more than 10 years in Data Modeling, Database Development, Performance tuning, analysis, ETL, Data Migration and Database Administration activities in high transaction volume databases in OLTP/OLAP environments.
  • Extensive experience in Conceptual/ Dimensiona / Physical/Logica database design, database application interface, performance tuning of database, PL/SQL, SQL, ET and planning and implementing suitable database Security / Maintenance Strategies.
  • Extensive experience and knowledge in the Architecture Administration of the prevalent databases like Oracle, Sq Server, DB2 UDB Sybase.
  • Has a thorough understanding relationa database models techniques, memory structures, excellent organizational, problem solving and communication skills both technica non- technica and a track record of working productively with technica staff, users, senior Management and people from different cultura backgrounds.
  • Knowledge of Unix administration shel scripting K-shel including Perl.
  • Proven expertise in al phases of Software Development Life Cycle SDLC of various projects
  • Got many performance awards and appreciation letters from the clients. She is wel conversant with Six Sigma ISO 9001 quality procedures, while executing her projects.
  • Experience working in different domains like utilities, insurance, consumer finance and financia industry.
  • More than 8 years experience in Wal street.

TECHNICA SKILLS

Operating Systems

Sun Solaris 2.7/2.8, Windows NT /XP/2000, Linux

Programming

Shell, Perl, SQL, PL-SQL, T-SQL,

Databases

ORACLE 11g/10g/9.x/ 8.x/7.x, MS SQ Server 2000/2003/2005, DB2 UDB 8.1, Sybase

Tools Utilities

Power Designer, ERWIN, Visio , Db Artisan , STATSPACK, TOAD, SQ Loader, Informatica Power Center, Oracle Enterprise Manager, Power Designer , Clear case, PVCS , Query Analyzer, Rapid SQL, SSIS, DTS, Db Studio, Autosys

PROFESSIONA EXPERIENCE

Confidential

Senior Database Consultant

Responsibility :

  • Identifying and Understanding the business requirements for smal group porta from different stakeholders/ user departments and effectively transforming it into a conceptual/ logical/ physica database mode which meets the operationa reporting objectives.
  • Writing database packages, Stored procedures, database triggers, creating Database Tables, indexes, views etc for the smal group portal.
  • Doing performance tuning of the database query tuning, indexing, object leve tuning etc for existing applications to improve the user experience for the portals.
  • Giving technica help to the application developers.

Environment

Oracle 11g, Sun Solaris, Visua Studio.

Confidential

Senior Database Architect

Serving as Senior Database Architect for collatera management unit in the Globa Collatera Infrastructure team.

Responsibility

  • Data modeling and design of the application data and reports structure, storage and integration
  • Database analysis, design and build for data remediation, reporting and stabilization to meet the long term business objectives.
  • Ensure the database designs fulfil the requirements, including data volume, frequency needs and long-term data growth
  • Development of cross-application data and distribution strategies
  • Work with the technica architects and application designers to develop the data conversion procedures and applications

Environment

Oracle 10g, ERWIN, DBArtisan, Power Designer, Sun Solaris, SVN

Confidential

Technica Manager/ Database Architect

Responsibility

  • Designing and normalizing/ denormalizing the database for enhancements and new applications belonging to GCH group.
  • Maintaining the Conceptual, Logica and Physica Mode for al databases collatera Management Security Master belonging to the group.
  • Understand business requirements from business analysts and act as database expert to the development team during the design, development and testing phase for enhancements/bug fixes in the applications.
  • Analyzing the causes for performance problems in the databases related to al applications belonging to Brokerage Securities Group and tuning the application queries, database memory allocations, parameters, object leve tuning etc.
  • Managing team of 5 at onsite and interacting guiding a team of 10 at offshore responsible for doing the production support for applications belonging to the Globa Collatera Hub including Security Master in the WSS group in JP Morgan.
  • Providing inputs, clarifications for any work to be undertaken by the project team at onsite/offshore.
  • Planning, coordinating and monitoring the project as per the schedules reporting to higher management.
  • Creation Monitoring of DB Loading jobs for the Globa Collatera Hub Securities Group.
  • Lead effort for writing stored procedures, database triggers, creating Database Tables, indexes, views, Snapshots, setting up autosys jobs.

Environment

Oracle 10g, ERWIN, TOAD, Autosys, Oracle Developer, Sun Solaris, Peregrine, SVN

Confidential

Database Architect Application DBA

Responsibility

  • Responsible for al activities related to the logica architecture of data, metadata and its lifecycle from data entry into the group, usage, persistence, and exit from the group.
  • Identifying and Understanding the business data requirements from different stakeholders/ user departments and effectively transforming it into a conceptual/ logical/ physica database mode which meets the operationa reporting objectives.
  • Normalization / de-normalization of the Database design to bring about a best possible design for the application.
  • Construct relationa databases, optimize database performance, resource use, and address database integration issues for new existing applications , database migrations involving different databases MS-Access, Oracle, Sq Server, Sybase ,Db2 UDB etc , database integration, maintenance, conversion and capacity planning issues.
  • Analyzing the causes for performance problems in the databases size more than 1 Terrabytes related to al applications belonging to Systems Management group and tuning the application queries , database memory allocations, resizing storage parameters, object leve tuning etc.
  • Monitoring the performance of the database using IWATCH, TOAD, Sq Server Management Studio, DB Artisan OEM and collecting statistica information about the performance of the database and doing proactive performance enhancement.
  • Writing Stored procedures, database triggers, creating Database Tables, indexes, views, Snapshots, setting up data loading jobs, monitoring jobs in Oracle, Sq Server UDB databases.
  • Use SQ Loader, DTS, SSIS Informatica ET for loading and transforming data between databases in Oracle, SQ Server, and DB2.
  • Giving technica support and guidance to the development team in al phases of SDLC.

Environment

Oracle 9 i / 10g, Sq Server 2003/2005, DB2 UDB 8.1, Linux, Sun Solaris 2.8, Clear case ,SVN, IWATCH 5.0,Power Designer 9.5,DBartisan, RapidSql, Toad, Informatica, DTS, SSIS, Power Center, Windows NT

Confidential

Coordinator cum Applications DBA

Responsibility

  • Maintaining the Database Design using ERWIN.
  • Ensure availability, confidentiality integrity of databases through security practices multiple access schemes, and facilitate sharing of common data across applications.
  • Monitoring the performance of the database using DBArtisan Toad and taking preventive proactive measures to keep the performance within the prescribed standards.
  • Understanding the business requirements for enhancements and transforming them to database solutions to meet the operationa reporting needs.
  • Address application database interactions issues and get them resolved.
  • Coordinating with the offshore team for resolving maintenance requests for existing applications.
  • Acting as a technica guide to developers for effective query writing.
  • Providing inputs, clarifications for any work to be undertaken by the project team at offshore.
  • Planning, coordinating and monitoring the project as per the schedules reporting to higher management

Environment

Oracle 8 i /9 i on Sun Solaris 2.8, PVCS, DBArtisan, Toad, Developer 2000, PL-SQL

Confidential

Lead Database Architect

Responsibility

  • Leading the team of Database Architects and guiding the team in understanding the business requirements functiona requirements in order to create the conceptual/logical/physica mode of the database.
  • Creation of the Logica physica mode for different modules of the project using ERWIN.
  • Normalization / de-normalization of the Database design to bring about a best possible design for the application.
  • Giving technica support to the development team in application query tuning to bring out the best performance.
  • Creation of storage objects sizing them based on estimated growth of each database element.
  • Monitoring the performance of the database and tuning of queries, stored procedures, initialization parameters of the database etc.
  • Loading data using SQ loader.

Environment Oracle 8 i on Sun Solaris 2.8, ERWIN 4.1 with Mode Mart, MKS 8.1

Confidential

Application DBA

Responsibility

  • Creation of users, table spaces, rollback segments, data files and their administration Loading of data
  • Technica support to the development team in tuning the queries for report development to get the best performance.
  • Installing and configuring the PeopleSoft HRMS client application on the client machines.

Environment Oracle 8 i on Sun Solaris 2.8, PeopleSoft 8.0 on Windows NT

Confidential

Consultant Database Architect / Applications DBA

Responsibility

  • Understanding the business requirements from the client and effectively transforming it into a database solution, which meets the operational, transactiona reporting objectives.
  • Creation of logica physica database design using ERWIN.
  • Creation of users, table spaces, rollback segments data files granting/ monitoring access contro of the database objects.
  • Tuning the application for performance.
  • Ensuring compliance of the database with the GEFA standards
  • Deployment of the database and implementation of the IAS connection pooling for al the applications
  • Overal maintenance/support for al the databases involved including monitoring of various data loads from the businesses to the different databases.
  • Got awarded by GEFA for excellent performance

Environment

Oracle 8.0 8 i on Sun Solaris 2.8, IAS iPLANET Web server

Confidential

Consultant DBA

Responsibility

  • Creation of logica physica database design using ERWIN.
  • Creation of users, table spaces, rollback segments, data files and their administration
  • Loading of data from other data sources.
  • Access Contro on the database objects by the different users.
  • Setup of backup and recovery procedures
  • Ensure that the databases are up and running al the time 24x7
  • Tuning of the application database objects.

Environment

Oracle 8 8i Servers on Sun Solaris 2.6, Windows-NT

Confidential

Consultant Applications DBA / Project Leader

Responsibility

  • Understanding the user requirements from various departments in JNPT and effectively transforming it into a database solution, which meets the operational, transactiona reporting objectives.
  • Creation of logica physica database design using Designer 2000.
  • Creation of the physica schema design of users, table spaces, rollback segments and data files.
  • Analyzing, testing implementation of physica database design to ensure that data recovery, maintenance, data integrity and space requirements of the database are met through proper parameter formulations.
  • Setting up Backup and Recovery strategies procedures for the logica and physica backups.
  • Converting data from legacy systems VSAM to Oracle RDBMS solutions.
  • Performance monitoring and fine tuning of the application database.
  • Acting as a technica guide to the application development team.

Environment

Digita Unix, Developer 2000, Oracle 8.0.

Hire Now