SUMMARY:

• Over 7 Years of experience in Information technology (Administration) industry
• 6 years of experience using SQL 2000, SQL 2005 and SQL 2008 servers
• Over 4+ years of experience working as Oracle DBA
• Over 2+ years of experience working as Oracle PL/SQL
• Over 1+ years of experience in Database Testing
• Experienced in Oracle 8i, 9i, 10g
• Reporting services from SQL server 2008 R2 (SSRS) and ad - hoc reporting through querying analysis services.
• Analysis services from SQL server 2008 R2 (SSAS).
• Data integration on SQL servers (SSIS) and ODBC from multiple data formats

  Conducted ETL (Extract, Translate, Load) on multiple database formats

  Experience in MSSQL Server installation, configuration, performance tuning, query optimization, running Database Consistency Checks using DBCC commands.

• Over 4 Years as an Oracle DBA, Senior Developer in SQL & PL/SQL in Development and Production Environments under UNIX and Windows Platforms
• Extensive experience in Oracle Software Installation, Up gradation, Migration, Capacity Planning, Database Creation, Database, Performance Tuning, User Management, Net Configuration and Troubleshooting
• Provided Support for Implementing, Upgrading various new and third party Application in client site
• Assisted with impact analysis of any changes made to database objects
• Implementing High availability technologies includes Replication, Log shipping and mirroring as a Continuity of Business techniques
• Administered all database objects including tables, clusters, indexes, views, sequences, packages and procedures
• Implementation and maintenance of database securities like creation of users and roles, assign privileges
• Hands on experience in performing the capacity planning which required creating and maintaining the databases
• Hands on experience in performing database re-organizations as required, assisting performance and ensuring maximum uptime of the database
• Knowledge in migrating code, database changes, data and menus through various stages of the development life cycle
• Experience with Unix and VB scripts on Unix and windows platforms
• Excellent experience in OLAP and OLTP designing
• Sound knowledge in understanding business requirements
• Sound communication skills with management, development teams, vendors, systems administrators and other related service providers
• Hands on experience in creating Databases, Undo Management and managing Tablespaces
• Planning, Scheduling Backups and Logical Backups
• Expertise in Logical and Physical Database Design, Development, Deployment and Administration for 24X7 Production Systems with Oracle Database
• Extensive experience in software development, testing and implementation
• Extensive Experience in PL/SQL Procedures, Triggers, Functions and Packages
• Expertise in General Database Administration and Backup & Recovery etc
• Expertise in the data Migrations using Data pump 10g, Export/ Import 9i
• Expertise in managing profiles and roles
• Experienced in Flashback Query, Transportable table spaces
• Strong Trouble-Shooting, Problem Solving, Analytical and Design Skills

TECHNICAL SKILLS:

Operating Systems: R H Linux, Sun Solaris 8, Windows NT/2000, Windows 98/Xp

Database: MSSQL Server 2000/ 80, MSSQL Server

2005 and 2008, MS: Access, Oracle 8i, 9i, 10g

Scripting: Shell (bash/ksh), Dos(.bat)

Tools: and Utilities Enterprise Manager, Query Analyzer, SQL ServerProfil er, SQL Server Management Studio, SQL*PLUS, iSQL, SQL* Loader, TOAD, Export/Import, Data Pump, TKPROF, OEM, Optimizer, RMAN.

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS)

Languages: SQL, PL/SQL

.Net Technologies: ASP.NET 1.1, ASP.NET 2.0, C#, VB.NET, ADO.NET

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

SQL and Oracle Development DBA

Responsibilities:

• Worked on SQL server 2000, 2005, 2008
• Worked on database migration from SQL
• 24X7 on call support
• Involved in Migrating and Creating 100s of DTS packages to SSIS packages and reports using SSRS
• Extensively worked with Excel including Pivot Tables and analysis - setting up ODBC connections for creating reports.
• Implemented Mirroring with SQL Server 2008 successfully.
• Involved in Installation, Configuration and Upgradation of Oracle software and related Software Products.
• Involved in Physical and Logical Database Design, Architecture and Implementation.
• Performed daily Hot Backups and weekly Cold Backups and recovered the databases on SQL Server 2000
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, SQLCMD and dedicated admin connection.
• Developed Oracle PL/SQL code based on requests raised by changes in business logic, norms and standards
• Created multiple instances for different applications
• Created database, tablespaces, tables, views, Users and permissions and set up environment on Oracle 11g.
• Created, Maintained various Views and PL/SQL Stored Procedures, functions and Packages for the Application. This includes making changes to support fix bugs, new Enhancements or Performance Improvements.
• Managed all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
• Worked on Optimizing T-SQL and PL/SQL queries
• Created Users, Roles, Tablespace, Assign the quota to users and maintained Segments and managed the privileges.
• Involved in design, implementation and testing the ERP solutions on SQL Server 2000 using C#

Environment: SQL Server 2000, SQL Server 2005, SSIS, SSRS, Toad 9.1, Oracle 8i, 9i, 10g,11g, Windows 2000, UNIX, SQL, T-SQL, ERP, SQL*plus, RMAN, Import, Export

Confidential, Indianapolis, IN

SQL DBA/Security Advisor

Responsibilities:

• Managed and Administrated theSQL Server 2008/2005/2000 production and Non-production servers.
• Installation ofSQL Server 2008/05onWindows Server Clustered environment.
• Upgraded/Migrated SQL Server 2005/2000 databasestoSQL Server 2008 databases.
• Migrated SQL Server 2000 databasestoSQL Server 2005 databasesincludingDTS to SSIS packages.
• Performedbackup using backup compression and Data compression in SQL Server 2008 on clustered environment
• Responsible for provisioning User Access Security, which includes adding/updating/deleting users for over 100 applications, using SQL Server 2005
• Managed Security usingSQL Logins, Roles and Security Modesfor various users.
• Optimized the query performance with modification inTSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins,creating usefulclustered indexandnon-clustered indexes.
• Import data across multiple instances using BULK INSERT and BCP Utility
• Create and manage database objects that include Tables, Views, User-defined Functions, Stored Procedures, Constraints and Triggers to implement Business Logic.
• Create Clustered and Non-Clustered Indexes to improve the performance of database access.
• Extensively involved in transitioning all Client Server Development (CSD) applications to Access Management team, in order to improve the time and efficiency of user access provisioning process
• Completed in all technical courses related to User Access Security
• Involved in writing and maintaining complex PL/SQL queries on Oracle 10g database for providing user access at the database level
• Involved in resolving issues in a timely, accurate and thorough manner
• Developed Standard Operating Procedures (SOPs)
• Developed and identified failures insecurity policies, standards, procedures and guidelines
• Involved in Security Admin (sa), creating users, assigning roles and privileges
• Extensive experience in implementing and supporting Oracle 10g and OEM in windows environment
• Planned Backup & Recovery procedures, Performed Backup and Recovery activities both in archive & no archive modes (Hot/Cold)
• Involved in performance tuning using Statspack, AWR and Tracing
• Developed the project plan for the implementation of CSD- Access Management Transition project
• Developed technical documentation and gave several presentations
• Migrated database objects from development and test environments to production environments
• Provided on call support for production databases
• In the front end, made use of Grid View to display data in a customized format in the ASP.NET web pages

Environment: SQL Server 2000/2005/2008 (Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), MSSQL Server2000 Analysis Server), Oracle 10g, OEM, Java, ASP.Net, MS Access, ICE (Identity Central Express), Windows2003/XP, TOAD, Database Triggers, Active Directory, LDAP, MS IIS

Confidential, San Ramon, CA

SQL DBA

Responsibilities:

• Created and maintained all databases as per the requirements for development, testing, and production Environments.
• Involved in analyzing, developing and testing new module Donor Express where customer donates items based on inventory status
• Microsoft SQL Database Administration including 2005, and 2008 R2 DBA technologies;
• Manipulating data using Microsoft SQL Server Integration Services (SSIS);
• Modeling Relational and dimensional database including both logical and physical; and
• Developing database reports using Microsoft SQL Server Reporting Services (SSRS).
• Managing all database objects, including tables, clusters, indexes, views, sequences, packages and procedures
• Upgraded different modules from older version to current version of Uniface
• Analysis, design, development, testing, deployment, and documentation of software solutions
• Involved in Optimization, Performance tuning, fine-tuning of layers of the database by modifying the file structure and Organization, scheduling index rebuilds, and other hardware-type decisions.
• Exporting, Importing, Transactional Replications, and creating Snapshots of data
• Designed, developed and maintained various OLAP and OLTP applications
• Controlled migration of programs, database changes, data changes and menu changes through the development life cycle
• Worked with VB Scripts
• Incorporated ASP.Net validation controls in the front end and web services
• Document system configuration and enhancements and Create and maintain technical standards, policies and documentation
• Performed Integration testing for checking complete functionality of various modules

Environment: SQL Server 2008, SQL Server 2005, XML, Sun Solaris (Sun OS 5.6), Oracle Web Server (OAS), C++, HTML, Servlets, JSP, JavaScript, Perl, C, Power Builder, SQL Navigator.

Confidential, San Jose, CA

Oracle Developer

Responsibilities:

• Performed daily Hot Backups and weekly Cold Backups using RMAN.
• Created new Tablespace, added Data Files and resolved Disk Contention Issues.
• Granted/Revoked Permissions to/from DBA and users. Enforced usage of Roles.
• Allocated system storage and database storage structures (tablespaces) and planned for future storage requirements for the database systems.
• Assured that Daily Backups and Archiving were done accurately and consistently.
• Monitored and optimized the performance of the database and offered assistance to developers in optimizing their applications, queries, etc.
• Used Crystal Reports to generate the reports
• Loaded data into Database using the SQL Loader, Export, UNIX shell script Batch File and managed system Events and Jobs using OEM.
• Database Migration from 8i to Oracle 9i.
• Worked on VBScripts
• Assured Load balancing, monitored disk I/O statistics, Data file I/O statistics, read/write ratios and fixed problems.

Environment: Oracle 8i/9i, SQL PL/SQL, SQL Loader, RMAN, Import, Export, Oracle Enterprise Manager (OEM), Advance Replication, Advanced Queuing, TOAD, Sun Solaris, HP-UX and Windows NT.

Confidential

SQL Database Administrator

Responsibilities:

• Designed and implemented multiple systems using MS SQL Server 2000
• Developed T-SQL code based on requests raised by changes in business logic, norms and standards
• Created Users, Roles, Assign the quota to users and maintenance of Segments and managing the privileges
• Prepared estimates for database and table size growth and designed database tables as per technical specifications
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.
• Monitor connections, locks and performance of SQL server.
• Designed and implemented high availability solutions like Mirroring, Log Shipping, SQL Clustered Configurations
• Created and managing schema objects, storage allocation, rollback segments management, constraints.
• Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers, stored procedures, views, rules, Defaults, user defined data types, and functions.
• Investigate for possible reasons of errors by studying backend code, and scripting as needed to resolve issues.
• Responsible for MS SQL Server 2000 configuration, tuning and provide 24X7 dedicated support to all Production, development and cluster servers.
• Performed all aspects of database administration, including backups andrecoveryUsed utilities Import and Export performed the re-org of databases
• Performed Unit Testing and Quality Assurance activities on the codes developed by various team members
• As a part of the Infinity project, modified Oracle procedures for downloading data from Finacle, and SQL Loader scripts for uploading into Bankaway database
• Developed and modified PL/SQL packages, procedures, functions, triggers as per the customer requirements
• Provided functional and technical support to the users.

Environment: SQL-Server 2000, DTS, SQL Diagrams, Erwin, Windows 2000 Server, MS Access, MS Excel, MS Analysis Services, MS Reporting Services, HTML 4.0.

Confidential

SQL developer

Responsibilities:

• Creating and managing schema objects, storage allocation, Undo Management, Constraints, Database Access control and Roles and privileges.
• Managing the resolution of support service issues, queries and enhancements.
• Created and maintained all databases required for development, testing, and production usage.
• Involved in E-R data modeling using Erwin.
• Developed and modified PL/SQL packages, procedures, functions, triggers, reports as per customer requirement to make new enhancements or resolve problems
• Fixing errors in data for various clients by using GUI interface of application or PL/SQL scripting.
• Communicating and discussing with client and support team to research and resolve a perceived issue or problem.
• Planed and implemented HOT and COLD backup and recovery of the Oracle database through RMAN, Import and Export Created procedures to correct the discrepant data.
• Troubleshooting and resolving issues in various aspects of the health/ dependent care module like claims, card management, enrollment, transactions etc.
• Developed documentation to support the business and the support team.
• Implemented most of the functionalities in C#.
• Developed migration plan from existing production system to new hardware upgrade.
• Upgrading different modules from older version to current version of Uniface
• Extensive Performance Tuning, Memory (SGA) Tuning, etc.
• Performed Unit testing for the scripts modified

Environment: Oracle 9i, C#, Windows 2003 Server, SQL*plus, TOAD, SQL*loader, PL/SQL, SQL Navigator.

Confidential

SQL Developer

Responsibilities:

• Create Databases, Tables, Indexes, Views, Triggers and Stored Procedures on Query Analyzer.
• Tested and Tuned Stored Procedures and indexes for better performance.
• Used DTS utility for transferring the data.
• Wrote scripts for text processing using PERL and Windows Scripting.
• Created Views, Materialized Views and Triggers for security purposes.
• Used BCP utility to transfer the data from summary tables to flat files.
• Extensively worked on different Replication Models including Snapshot and Transactional Replications.
• Created clustered indexes on the tables which have frequently used data
• Wrote and executed certain triggers to ensure that any update or delete operation gets correctly reflected in backend
• Created schemas to allow separation of user operations and for clarity of operation on different database tables.
• Designed a report on the monitoring of Server Performance using Task Manager. This report gives a detail report to the management on the Performance of the server.

Environment: SQL Server 2000 Enterprise Edition, T-SQL, Query Analyzer, Enterprise Manager, Windows 2000/ NT, MS Access, MS Excel.