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 Server Profiler, 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 2000 to 2005
• 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 training 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, reference 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, VA

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, NH

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, Burlington, NC

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.