We provide IT Staff Augmentation Services!

Database Administration And System Analysis Resume

EXPERIENCE SUMMARY

  • Total around 11 + years of experience in Database Administration and System Analysis
  • Experience in Design, Development & Support of MS SQL Server 2008 R2, 2005, 2000, 7.0 and Oracle 9i/10g/11g in Production, Testing and Development with Log Shipping, Mirroring, Replication and Clustering using the virtual Environments (managed MS SQL Server Cloud using VMWare Vsphere 3.5 and 4.0).
  • Expert in MS SQL Server installation, configuration, client/server connectivity, query optimization, back-up/recovery, running DBCC Commands.
  • Expertise in transforming data from one server to other servers using tools such as BCP, DTS, Bulk Insert and SSIS.
  • Expert in RDBMS concepts and constructs to design relational databases model and implementation as per business needs. Expertise and Interest include Administration, Database Design, Performance Analysis and Production Support for Large (VLDB) and Complex Databases up to 2.5 TB.
  • Experience in using SEM for database monitoring and maintenance.
  • Expert in importing and exporting data from Excel, Flat file, Oracle to MS SQL Server databases by using BCP, DTS, SSIS utilities. Expertise in Performance Tuning, Auditing, cloning, Optimizations, Indexing, Security Management and Remote Administration.
  • Excellent in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent. Experienced in designing Disaster Recovery models for corporate databases.
  • Expert in Creating, Testing and Implementing SSRS packages for Reporting Services. Working knowledge in creating and deploying cubes. Administered all SSAS instances and worked on SSAS in order to analyze grouped data and aggregate it into different formats and views.
  • Extensive exposure and experience in RMAN backup and recovery, performance tuning (using stats pack, OEM Diagnosis pack and tuning pack, 10g AWR, ASH and ADDM), database analysis and troubleshooting.
  • Installation and configuration of RAC, Data Guard, physical and logical standby and other high availability and disaster recovery.
  • cStrong in SQL Tracing (profiler), T-SQL and PL/SQL Database programming - Development of Stored Procedures, Cursors, Triggers & Views, both on SQL and Oracle Databases.
  • Extensive knowledge and experience in data modeling, logical and physical database design using Erwin, Oracle Designer, Power Designer, and TOAD.
  • OLAP experience like Analysis Server 2005, SSRS Reporting Services, Business Intelligence, Integration Services.
  • Providing technical support 24x7 for mission critical production databases and app’s.
  • Experience supporting applications as ADBA’s.
  • Maintaining client focus and strengthen client relationships through quartelry CSR’s. Preparing action plans for areas of CSR improvements.

TECHNICAL EXPERTISE

LANGUAGES: BASIC, PASCAL, C, C++, JavaScript, Java 1.1, Java 1.4.2 , 1.5 and 1.6, SQL, Unix Shell Scripting, Perl, PL/SQL Programming.
DATABASE(S): MS SQL 7, 2000, 2005 & 2008 R2, Oracle 7.3, Oracle 8i, 9i, Oracle 10g, 11g R2, DB2.
APPLICATIONS/TOOLS: SQL Profiler, , Import & Export (DTS), SSRS, SSAS, SSIS, Erwin, BMC Patrol, Oracle export/ import utilities, OEM, RMAN, TOAD, SQL Backtrack, Data Guard, SQL Trace, DBMS Stats, STATS Pack. Ms Office 97,2000,XP,2003, Ms Projects 2000, 2003, Ms Visio 2000, 2003, Q Messenger, Patrol, NetCool, Vantive, Introscope.
WEB TECHNOLOGIES: PWS4, IIS 5.0, 6.0, APACHE2, TOMCAT SERVER, Weblogic, Websphere 6 & 7.
OPERATING SYSTEMS: Linux (RHEL), Sun-Solaris, AIX, HP-UX, DOS, Windows 2008 2/2003/2000/XP
HARDWARE PLATFORMS: IBM SERVERS, HP SERVERS, SUN SPARK MACHINES, INTEL CHIPSET SERVERS.

PROFESSIONAL EXPERIENCE

Confidential, USA.
Lead DBA (Oracle and MS SQL) Aug 2008 Till date
  • Migrated Databases from SQL Server 2000 to 2005 and 2008 R2 in Production and test Environments. Involved in Migrating of database from one server to another
  • Involved in Data modeling, designing and building relational databases.
  • Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of databases. Backup and recovery of production databases and tuning production databases for better performance.
  • Creating databases and logins with permissions in SQL and Oracle servers as per the developer’s request.
  • Created and monitored Database maintenance plans for checking database integrity, data optimization, rebuilding indexes and updating statistics.
  • Configured Mirrored database. Worked on high availability SQL Server solutions, including Log shipping and SQL Server clustering.
  • Database monitoring and maintenance using SEM (SQL Enterprise Manager)
  • Implemented Pager options to inform corresponding DBA basis on Each Job Status.
  • Enrolled users and maintained system security for SQL Server databases.
  • Created and Modified Tables, Stored Procedures, Views, Indexes, User-defined Functions and Triggers etc as required on the SQL Server and Oracle Databases
  • Working with database Monitoring and Tuning. Lead efforts to develop and improve procedures for automating monitoring.
  • Maintains the scripts in Share point. Incident management using BMC Remedy
  • Creation and configuration of Oracle 10g database and SQL Server
  • Migrated Databases from SQL Server 2000 to 2005 and 2008 R2 in Production and test Environments. Involved in Migrating Oracle Databases from Oracle 9i to 10g in Production and test Environments. Involved in Data modeling, designing and building relational databases.
  • Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of databases. Backup and recovery of production databases and tuning production databases for better performance.
  • Creating databases and logins with permissions in SQL and Oracle servers as per the developer’s request. Created Linked Servers between SQL server 2000 / 2005 and Oracle server in the environment.
  • Created and monitored Database maintenance plans for checking database integrity, data optimization, rebuilding indexes and updating statistics.
  • Configured Replication Server, worked on replication server. Worked on high availability SQL Server solutions, including Log shipping and SQL Server clustering.
  • Database monitoring and maintenance using SEM (SQL Enterprise Manager)
  • Administered all SSAS instances and worked on SSAS in order to analyze grouped data and aggregate it into different formats and views. Created SSIS packages to export data from Oracle to SQL Server Database.
  • Data volume estimation and planning. Created partitioned tables and indexes, bitmap and function based indexes and materialized views to improve the performance of all databases on Oracle 10g.
  • Optimized the Disk space for performance using RAID and SAN. Monitored and maintained daily loads, modified production run UNIX shell scripts and provided general day-to-day DBA support on all Oracle Servers.
  • Created and Modified Tables, Stored Procedures, Views, Indexes, User-defined Functions and Triggers etc as required on the SQL Server and Oracle Databases
  • Maintains the scripts in CVS. Example adding the scripts to CVS, tagging the production and making use of production copy by exporting to local directory.

Environment: Windows 2000/2003, Linux/UNIX OS, IBM AIX, SQL Server 2000/2005/2008 R2, Oracle 10g/9i, RAC, PL/SQL, Erwin, SQL Profiler, DTS, T-SQL, SSIS, SSRS, SSAS, BCP, XML, Perl, TOAD, OLTP, LDAP, RMAN, JIRA, Remedy, SQL Profiler, DTS, Remedy.

Confidential, USA
SQL server/Oracle DBA June 2007 July 2008

  • Login and User management: Adding logins, roles, groups to the window NT and MS SQL Server and maintaining proper security procedures. Scheduling Jobs and Alerting security procedures.
  • Database creation, database tuning, performance planning, backup planning and database administration for SQL Server 2000 / 2005 and Oracle 9i. Proactive and Reactive tuning of databases in every stage of the project.
  • Materialized views, dimensions and stored outlines for optimal performance. Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
  • Migrated Databases from SQL Server 2000 to SQL Server 2005 in Development and test Environments. Configured Snapshot Replication using Snapshot agent. (Creating Distribution Databases, creating & managing Publications, managing Replication monitors).
  • Experience in Installation of SSRS. Hands on generating different types of Reports using SQL Server Reporting Services (SSRS). Performed the ETL operations to support the data loads and transformations using SSIS.
  • Worked on SSAS in order to analyze grouped data and aggregate it into different formats. Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers. Monitored Performance during Beta Testing phase of the application.
  • Worked with generating reports using Microsoft Reporting Services. Administered SQL Servers from Perl, by performing administrative tasks using Perl Scripting. Prepared documentation to set standards, guidelines and best practices for SQL Server Database Installation, Administration, Backup & Restore Procedures, Database Security and SQL Database Development.
  • Installed, upgraded and tuned Oracle both on Windows NT and Linux Servers. Planned for backup and recovery of database information using RMAN.
  • Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions and Triggers etc as required for both SQL Server and Oracle Databases.
  • Used Remedy to successfully map, track and enforce defects and issues throughout the entire life of development projects

Environment: SQL Server 2000/2005 Enterprise Edition, SEM, Oracle 11g/10g/9i, HPUX 10, SQL Server Enterprise manager, Erwin, , SSRS, MS Reporting Services, SSIS, BCP, XML, DTS, T-SQL, TOAD, RMAN, Unix Shell Scripts, Remedy.

Client British Telecom,
UK.SQL Server DBA/ Oracle DBA Sep 2005 May 2007

  • Working closely with the LAB admin for setting up the environments.
  • Configuration of Clariion and Symmetrix storage system for the SQL Server Environment.
  • Developed Monitoring, backup and recovery scripts for the SQL Server database.
  • Developed original system for tracking database objects (tables, views, procedures, etc.) over multiple SQL Servers and Oracle servers.
  • Creating tablespace in the oracle, taking replica, mounting the single tablespace restoring the single tablespace.
  • Making structural changes to the databases when database design changes are to be implemented
  • Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
  • Extensively Developed SQL scripts for maintaining administration tasks.
  • Configured Oracle RAC (Real Application Cluster) for high availability which supports the application (RM).
  • Replicating the oracle, UDB, SQL, Exchange using the replication technologies, snapview, clone, BCV, SANcopy.
  • Testing is done with the automation framework to check the health of Environments. The scripts were ran everyday. Fixing the issues generated by this script run.

Environment: ORACLE 9i/10g/ASM, UDB, SQL Server, Solaris9/10, AIX, HP-UX, RH Linux AS3.0, Windows, Clear Quest, VxVM, LVM

Confidential, Singapore.
SQL Server DBA Aug 2004 - Aug 2005

  • Installation and configuration of SQL Server 2000 on Window 2000 / NT OS.
  • Managing of database objects like Tables, views, stored procedures, indexes etc. Written complex stored procedures and functions according to business requirements.
  • Implementing Backups and restoring when necessary.
  • Developed DTS Packages to transfer the data between SQL Server database and files. Creation and management of Database maintenance plan for various database consistency checks.
  • Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
  • Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it. Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
  • Develop documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.

Environment: SQL Server 2000, Enterprise Manager, Windows 2000, SQL Profiler, DTS, Business Objects,
T -SQL, PL/SQL, BCP.

Client - Confidential
Software Engineer /SQL Server DBA Jan 2002 Jul 2004

  • Setting up test environment and Development by installation, configuring SQL Server.
  • Collaborated with Web developers on the backend design and development to support survey UI and applications.
  • Developed and created stored procedures, advanced queries, triggers, views, index and functions for databases.
  • Work with end users to define, implement and maintain their reporting requirements.
  • Developed and maintained complex DTS packages.
  • Maintaining scripts and other documents in PVCS.
  • Requests were handled from Remedy.
  • Used SQL programming knowledge to build internal data warehouse functionality
  • Developed and optimized stored procedures and triggers.
  • Developed SQL Server applications, translate data and manage implementation to ensure successful execution of the application
  • Troubleshoot databases and custom application issues
  • Performed DBA duties including: database backups, restores, performance tuning, and capacity analysis.

Environment: SQL Server 7.0, Enterprise Manager, Windows, SQL Profiler, DTS, Business Objects, SQL Server 2000, Windows 2000, PVCS, Remedy.

MY OTHER PROJECTS (In Reverse Chronological Order)

Confidential, Singapore
Jul’01Dec’01

R-XML is a remote access and Storage Management Software Package. Remote Storage Management module facilitates the remote storage and access of DOC, PDF, XLS, RTF and JPG files through pre installed server directly through Internet and specified applications like MS-Word, MS-Excel, Acrobat Reader and Photoshop. This module converts any file into XML format with encrypted XML format and stores in a file and transports it through net and decrypts the file with authorized client license holder for a specific application only.

Confidential, UK
(In house) Dec’00 - Jun’01

This project is Web based project. Initially we have developed a company website for the online information then it has been converted into a web application to upload their client details to the central database which is located at Andhra Pradesh State Secretariat, Hyderabad, managed by a Administrator located at their office.

Confidential, UK
(In house) Jun’00 - Nov’00

This is project is also a Web based project; developed for the online control of their money flow and online status of work progress by residing at UK they can watch programs conducted in Andhra Pradesh State, India.

WORKSHOPS/TRAINING PROGRAMS ATTENDED

  • Microsoft Certified Systems Engineer, 2000.
  • Solaris Administration,, 10 days, January 2001
  • Oracle Database Administration, 10 days, December 2002,
  • Networking, Router Configuration, LAN, WAN Technologies, , 10 days, December 2002.
  • Implementation of Certification Authority
  • Installation and Configuration of Acquisition servers ,Distribution server ,VOD Servers in Lab environment
  • Configuration of Active Directory, ADS, Cluster, SQL 2005, SMS, MOM.
  • Validation of OS & Mediaroom Deployment
  • Microsoft SQL Server 2008 R2 Database Administration.

PROFESSIONAL CERTIFICATIONS

  • SQL 2000/2008 R2 Admin.
  • Oracle 9i/10g DBA
  • MCSE 2000.
  • CCNA (Cisco Certified Network Associate)

Hire Now