SUMMARY:

• Has over 10 years of experience in the analysis, design, development, implementation, testing, and maintenance of application systems in the Internet/Intranet, Client Server environments; with 5+ years of experience as a SQL Server DBA.
• Very good experience in Installation, configuration and maintenance of SQL Server.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• 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.
• Created complex DTS Packages for Data Migration and Transformation.
• Experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2008/2005 Experience in MS SQL Server upgrades from MS SQL server 2005 to MS SQL Server 2008.
• Worked in OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server.
• 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 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.

PROFESSIONAL EXPERIENCE:

Database Administrator

Confidential

Responsibilities:

• Installation SQL Server 2012, 2008 and 2005 on Windows 2003/2008, applied service packs and security fixes. Scheduled Sql Backups, Statistics, Index Rebuilds, and Cleanup Jobs. Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, User Defined data types and functions.
• Addressed the Replication Issues. Created new replications, DTS packages to maintain high availability of the data between the servers.
• Implemented the SQL Login Security for developers and users. Running DBCC consistency checks, and fixing data corruption in user databases. Involved in Planning and Monitoring Log Shipping.
• Creation of Schema objects, rules and granting of roles to the users. Worked and coordinated with developers in writing and tuning new stored procedures. Worked on DTS packages to import the data from Oracle, Access and text files. Setting up backups for the newly created databases.
• Scheduling transfer of backups and log files to different servers. Responsible for change managements, created the documents for SQL Server and service packs installations. Responsible to Install, Upgrade, Design, and Implementation of SQL Server 2005, 2008 and 2012 Enterprise and standard databases environment for multiple client’s sites Oversee and Assist database developers and web programmers in query writing, query optimization, performance tuning. Implemented the recovery process to restore lost data caused by users or system failure. Good experience in Project Documents, Installation Documents and User Manuals

Sr System Analyst Oracle Database /Sql Server /PeopleSoft Admin/Amos/Deltek

Confidential

Responsibilities:

• As a Sr database administrator, Desire was responsible for daily activities such as installing and creating multiple Oracle databases, Sql Server databases, Business Object, Amos, Deltek and PeopleSoft on a San environment. Setup Physical Standby Database using Dataguard, tune databases, Backup/Recover Databases, Apply Oracle patches, MS patches, monitor databases, upgrade SQL server instances from . Setup sql server backup.
• Set process to clean sql server logs. Monitor sql server performance of the database. Configure sql server mirroring. Refresh test and development databases as needed, create users and assign to specific group such as AP, AR, GL, Payroll. Migrate object such as projects, tables and views from development to production environment.
• Tune SQL processes for best performance. Create/Configure application servers, Process Schedulers, Web servers, Install Tuxedo, WebLogic, PeopleSoft People book, and Setup Load balancing to increase performance.
• Setup PeopleSoft Application Server load balancing.
• Cleanup PeopleSoft Caches and load Caches for best performance. Assist users, Developers with process such AP, AR, GL, and Payroll or Nvision queries that are taking too long to run with Tools such as Toad. Reduced SQL processes runtime in second. Desire tuned multiple databases and Application such as Oracle databases, Sql Server, PeopleSoft and other applications. Desire works on both Window NT and Window 2000/2003/2008 r2 platforms, Sql server 2005, 2008 and has installed Oracle 8I, 9I, 10G, 11Gr2, and PeopleSoft 7.5, 8.4.2, 9.

PeopleSoft Database Administrator

Confidential

Responsibilities:

• As a database administrator, Desire was responsible for eight databases ranging in size from GB. Daily activities included installing Oracle and PeopleSoft on the servers and client workstations; Schedule daily and weekly Backup.
• Tune multiple database instances, setup users, Apply oracle patches, PeopleSoft patches, and window patches. Schedule weekly or monthly maintenance to tune databases.
• Configure PeopleSoft application servers, Process Schedulers, and Web servers. Monitor databases. Reduced SQL processes runtime in second if possible.
• Migrate projects, objects into production environments. Assist developers, users, and testers in issues related to the database.
• Has written performance tuning scripts and scripts to support the Backup and recovery processes. Configure/troubleshoot workstation and laptop for users.
• Desire works on both Window NT and Window 2000 platforms and has installed Window NT, Window 2000, Oracle 7.1.6, 7.3.4, 8.0.5, 8i and PeopleSoft 7.5, 8.x.

PeopleSoft Database Administrator

Confidential

Responsibilities:

• As a database administrator, Desire was responsible for four databases ranging in size from GB. Daily activities included installing Oracle and PeopleSoft on client workstations; configure application servers, Process Schedulers, and routine monitoring of the database.
• Desire tuned both the Oracle instance and the database, executed daily incremental backups and weekly full backups, and applied fixes/updates to the database, created/modified tables, and assist developers, users, and testers in issues related to the database. Has written performance tuning scripts and scripts to support the Backup and recovery processes. Desire works on both Window NT and UNIX platforms and has installed Oracle 7.1.6, 7.3.4, 8.0.5, 8i and PeopleSoft 7.5, 8.x.

PeopleSoft Consultant

Confidential

Responsibilities:

• As a PeopleSoft Consultant, Desire was responsible for helping different client with performance tuning, Installing Application Server/Process Scheduler, Apply Patches/Fixes, Using Tools such as Toad and precise to Tune Queries for best response time at different client site, participate on an Enterprise performance management (EPM) Upgrade With others PeopleSoft Consultant, Help users troubleshoot Nvision and AP reports.
• Also as a shadow, Desire has help users troubleshoot Nvision and AP reports.