SQL Server Database Administrator

PROFESSIONAL SUMMARY:

SQL Server database administration and maintenance support for databases up to 3 terabytes, installation of SQL Server 2000, 2005, 2008 on Win 2003 and 2008 32 and 64 bit servers, T-SQL coding, backup/recovery, high availability implementations such as clustering, replication, log shipping and mirroring. Also performance tuning including index tuning, query modifications, and hardware optimization.

PROFESSIONAL EXPERIENCE:

March 09 – Present

Department of Corrections, State of Washington, WA

Information Services Solutions Group

Database Administrator

Managed and lead verdiem and timecard application projects.

-Maintained production systems on SQL Server 2005.

-Created database mirroring for high availability.

-Monitored SQL jobs; current activity; troubleshooting deadlocks, blocking issues.

-Upgraded/applied service packs and hotfixes for Windows 2003 and SQL Server 2005 database servers.

-Created reports using SQL Server Reporting Services.

-Built Windows 2003 Servers on IBM eserver xSeries 336.

-Presented Database Security Standards documentation as a guideline for new database application deployment.

-Troubleshooting and error resolutions to SSIS packages.

-Implemented MS SQL Server database monitoring solutions using spotlight.

-Created Tivoli TSM SQL backups and restores.

-Deployed database code to quality, demo and production environments.

-Managed Offender Management Network Information (OMNI), ATLAS database environments for the state.

-Helped in ensuring that Business customer SLAs are met at all times.

Environment: Microsoft SQL Server 2000/2005 including SSRS, SSIS; DB2, BMC SDE, Windows 2003 Server, MOSS

November 07 - February 09

Onvia

Database Administrator

Lead Database Administrator

-Supported and implemented technology projects as the Lead DBA in support of business initiatives.

-Implemented MS SQL Server database monitoring solutions using spotlight.

-Implemented enterprise wide backup/recovery solutions for MS SQL 2000/2005 databases.

-Responsible for team lead 24 x 7 DBA activities encompassing a diverse inventory of over (16) enterprise Microsoft SQL -Servers, representing all modern versions from 2008 through 2000.

-Responsible for directing the project and support activities for two database professionals.

-Lead and prioritized tasks for a database administrator and an engineer.

-Communicated regularly with development and support teams regarding database status and changes.

-Maintained production legacy systems on SQL Server 2000 and SQL Server 2005.

-Created log shipping, and transactional replication for high availability.

-Monitored SQL jobs; current activity; troubleshooting deadlocks, blocking issues; system performance.

-Created litespeed backup and restore jobs for disaster recovery purposes.

-Consolidated SQL Servers with SQL 2000 and 2005, reducing server count by 50%.

-Tuned long-running SQL queries to cut execution time, ease database load, and improve scalability.

-Monitored performance using SpotLight, SQL Profiler, Index Tuning, etc

-Recommend server configurations, disk capacity, RAID groups and LUNs setup.

-Deployed database schema, objects, roles, users, and permissions on Build, QA and PROD servers.

-Created 32 bit and 64 bit SQL server active/passive clusters.

-Installed SQL Server 2000 and SQL Server 2005 on high available clusters.

-Created Quest LiteSpeed backups and restores.

-Deployed database code to Qa, and Production SQL environments.

-Maintained legacy database code in Team Foundation Server.

-Generated new database schemas using VS 2008 database edition.

-Evaluating database administration software for the enterprise.

-Helped in ensuring that Business customer SLAs are met at all times.

Environment: Microsoft SQL Server 2000/2005, Windows 2003/2008 Server, Microsoft Visual Studio (Team Foundation Server) Database Edition, MOSS (Microsoft Office SharePoint Server), IIS 6.0/7.0, Crystal Enterprise 9.0, SCRUM, C#, ASP.NET, WCF Windows Workflow.

July 07 - November 07

Microsoft - Volt

Software Design Engineer II

-Managed Ad-Center SQL Server 2005 Databases.

-Litespeed backup and restore of databases to sandbox environments.

-Monitored SQL jobs, current activity, troubleshooting deadlocks, blocking issues; system performance.

-Created and maintaining Clusters (Active-Active, Active-Passive).

-Monitored system performance using Perfmon; SQL Profiler.

-Responded quickly to emergency situations whenever they arise.

-Deployed SQL code to sandbox, test and production SQL servers.

Environment: Microsoft SQL Server 2005.

October 06 - July 07

Department of Licensing, State of Washington,

Network Server Support

SQL Server DBA

-Provided design, tuning, maintenance and support of database systems for highly available, high-traffic Internet applications.

-Managed and Maintained SQL Server 2000 and 2005 Databases.

-Created SQL backups and restore of databases to lower environments.

-Created Logins, issuing permissions.

-Installed SQL 2005 on active/passive clusters.

-Migrated SQL 2000 databases to SQL 2005.

-Resolved SQL security/orphan login issues.

-Scheduled and monitored backups, maintenance plans, jobs, DTS packages.

-Created shares, groups, resources, failover using Cluster Administrator.

-Code promotion from QA to Production servers.

-Resolved open tickets for database code changes in production environments.

-Active Directory support.

-Created alerts on SQL failures using Microsoft Operations Manager.

-Recycled application pools in IIS and resolved MS Message Queue.

-Participated in 24x7 on call stand-by support.

-Responded quickly to emergency situations whenever they arise.

-Helped in ensuring that customer service level agreements (SLA) are met at all times.

Environment: Microsoft SQL Server 2000/2005, Windows NT 4.0, Windows 2000/2003 Server, Microsoft Operations Manager, Microsoft Clustering, IIS.

November 05 - October 06

Washington Mutual

Net Economic Value

Data Warehouse Developer

-Created mappings and scheduled the sessions.

-Created test plans in executing sessions in AutoSys.

-Prepared Reports using Informatica Repository Manager.

-Performed Informatica Administrator functions.

-Modified mappings and transformations in order to bring proper data into UAT.

-Executed testing in DEV Informatica 5.1 to Informatica 7.1.

-Tested UAT repository to bring Long Beach loans into UAT.

-Prepared UAT Deployment plans into PROD and DEV environments.

-Prepared reconciliation reports after loads are finished in UAT.

-Written SQL queries as a part of Oracle development in UAT.

-Communicated regularly with development and support teams regarding database status and changes.

Environment: Oracle 9.1, Informatica 5.1, TOAD 8.5, Unix.

April 05 - November 05

Washington Mutual

Direct Marketing and Customer Optimization

SQL Server DBA/Developer

-Created logins and granting permissions based upon business requirements.

-Managed table spaces, log files by using DBCC and System Stored Procedures.

-Created SAN disk group assignments and database file group layouts for optimal performance.

-Audited trace files by using SQL-Profiler.

-Created and automated regular backups on System tables.

-Created SMTP mail synchronization to the DTS automation process.

-Created and scheduled several packages to automate DTS Process.

-Enhanced and debugged several Stored Procedures and automated them on monthly -basis.

-Written views for specific users.

-Written ActiveX scripts in the DTS packages to change the data from Source/Legacy for automation.

-Written several T-SQL statements for business clients on ad hoc basis.

-Extracted, transformed and loaded the data from ftp sites into targeted databases.

-Helped in ensuring that Business customer service level agreements (SLA) are met at all times.

-Communicated regularly with development and support teams regarding database status and changes.

Environment: Microsoft SQL Server 2000, Oracle 9i, Microsoft Access, Microsoft Visual Basic, Microsoft Visio, Cygwin

October 04 - April 05

Washington Mutual

Capital Markets Research Group

Data Architect

-Created conceptual, logical and physical data models for relational and dimensional -databases.

-Reverse-engineer legacy databases to generate physical models.

-Developed test plans, evaluated results, written program specifications, and, prepared documentation.

-Helped in designing the Database Architecture for Capital Markets Research Group.

-Reviewed and offered recommendations for database system configurations.

-Approved database modifications resulting from product customization or design change requests.

-Created staging tables for data manipulation for Research Analytics group.

-Worked with application teams to incorporate T-SQL tuning and performance practices.

-Supported Software Engineers for their application development.

-Helped Technical Writers to prepare the documentation.

-Automated the monthly scripts and stored procedures using CVS.

-Communicated regularly with development and support teams regarding database status and changes.

Environment: SQL Server 2000, Oracle 9i, Toad 4.0, Cygwin, ERWin, MS Access, MS Excel, CVS.

May 03 - September 04

Prudential Financial

Real Estate Investment Portfolio

Developer

-Conducted deployments of objects and data through development, testing, replicated pre-production, and replicated production environments.

-Used Advanced Transact-SQL Queries.

-Written and used Indexes, Views, Triggers, and Stored Procedures.

-Written cleansing scripts to scrub the data in metadata area.

-Managed SQL Server Security, Managing Database Permissions.

-Developed an information-driven status decision support system for the Quality Planning Process.

-Used stored procedures to retrieve SQL Server Budgets and Finance data.

-Helped in data modeling and design using Erwin.

-Responsible for writing SQL queries to test the data validation and to check for incorrect data.

-Written some stored procedures to do the data aggregation and executed on monthly basis.

Environment: Oracle 8.0i, SQL Server 2000, Informatica 6.5, MS Excel, Access.

June 02 - March 03

University System of Maryland

Department of Information Systems

Developer

-Written SQL Scripts to query Oracle tables for quality assurance functioning.

-Used SQL*Plus to query the database and to ensure that the data retrieved from the -query application.

-Documented and presented details of the project using MS PowerPoint and Templates.

-Analysis and Programming support.

-Used SQL*Plus to query the database and to ensure that the data retrieved from the -query application.

Environment: SQL Server 2000, Oracle 8i.

May 00 - May 02

Advanced Telecom

Customer Billing and OLTP

Data Architect

-Worked with SQL Server DBA team with responsibility of creating all new policies and procedures to build, deploy and administer SQL Server 2000 High-availability clustered OLTP and standalone DSS database systems that perform portal B2B solutions.

-Experience with all phases of application development (e.g. requirements gathering, design, configuration, development, testing, conversion and application support).

-Developed customized data extraction routines using SQL*Loader.

-Performed as DBA managing table spaces, creating data files, indexes, synonyms, and views.

-Responsible for data modeling and design using ER diagrams and converting them into tables.

-Consulted with users to identify current operating procedures and clarify program objectives.

-Created and implemented hardware specification for three-tier (web/app/database) three staged (development/staging/production) server environment.

-Assisted Application Developers to solve their Database problems and concerns.

Environment: Oracle 8.0i, SQL Server 6.5, SAS V8, SQL*Loader, MS Access, UNIX.

EDUCATION:

-Master of Business Administration in MIS and Finance

-Bachelor of Commerce in Accounting

Nagarjuna University, India

CERTIFICATION:

-Microsoft Certified Professional (MCP) on Windows 2000 Server.

-Microsoft Certified Database Administrator (MCDBA) on SQL Server 2000.

TRAINING:

-EMC Host Clariion and Integration Management on May 19th, 2008.

-Microsoft SQL Server 2005 Upgrading Database Administration Skills.

-Informatica 6.2 and Informatica 7.1

Contact this candidate