SUMMARY:

• SQL Server 2000/2005/2008 Architect, DBA/Developer with over eleven years of experience with Confidential SQL Server.Responsible for evaluating, planning and implementing the integration of complex systems hardware and software in heterogeneous environments including Windows Server, Unix and MySQL & MSSQL databases over a Terabyte in size.
• Production DBA supporting 50+ servers, patching, updates change management, code releases, version upgrades. Enterprise database design and programming per management/customers complex specifications from concept to implementation. OLTP DB design and code and design review. Proactive approach to database design, development, and management, always exploring for ways to improve automate, enhance, optimize existing code, systems and processes. Mentored and managed other developers, DBAS’s in database design, standards and coding best practices and managed projects to timely and successful completion.
• MSSQL Server 2000/2005/2008 including data architecture and complex design of ETL, DTS and SSIS packages, design and implement reports using SSRS and Crystal, stored procedures, triggers, views, xml, in dot Net environment, SQL Server patches, upgrades and migrations, administration and monitoring of large corporate enterprise databases. Designed and implemented table partitioning - sliding window for archival. Ensure database security, integrity and performance. Data distribution Replication, T-SQL performance and application tuning and optimization for SQL Server based applications using SQL Server Profiler, Query Analyzer, System Monitor and advanced indexing techniques, created solutions that cut query and application execution times. Implemented and maintained transactional and snapshot replication. Create, maintain & monitor Sql Agent jobs (database backups, database maintenance, process automation etc.) Monitor critical database and system resources using Idera and SQL Server built in alerts.
• MySQL 5.1 Installed and configured MySQL Workbench, databases, developed stored procedures in MySQL. Migrate Sybase databases and stored procs to MySQL. Monitored MySQL replication, created MySQL database backups and restored databases from backups. Oracle DBA on Windows, configured Oracle as repository for WebSphere Application Servers. Perl and Ruby On Rails development.
• Disaster recovery business continuity and high availability, complex database backup and restore plans, SQL Native and 3rd Party - Redgate, log shipping, snapshot and transactional replication and data distribution. Maintain Windows/SQL HA Clustered Servers, database mirroring, log shipping, implement database performance analysis, tuning apply service packs, SAN knowledge.
• Windows 2003/2008 Server and Network Administrator, Unix/Linux System Administrator, C, Korn Shell and Perl scripting.

EXPERIENCE:

MySQL DBA/Developer

Confidential, CA

Responsibilities:

• Develop stored procedures for Confidential engine/application optimize and performance tune code - add indexes where necessary.
• Load data in to staging tables from customer provided files.
• Work with Business and Data analysts to ensure code adheres to specifications.
• Create ER Diagrams to represent database logical and physical models.
• Use Toad and Navcat for development in addition to Workbench.

MSSQL SERVER DBA

Confidential, Burbank, CA

Responsibilities:

• Provide support for databases servers that are clustered, mirrored or use log shipping for some level of high availability and disaster recovery.
• Monitor server performance and key metrics using native system monitoring and Idera that indicate system health and availability and remedy as necessary, perform backup/restores as necessary.
• Provide support to developers and users - permissions, access, respond to adhoc requests.
• Allocate additional disk space when necessary optimize stored procedures.
• Developed stored procs to rebuild/reorg indexes to enhance performance.

SQL Developer/DBA

Confidential, Los Angeles, CA

Responsibilities:

• Developed and implemented complex mission critical table partitioning and partitioning migration for ~ Confidential tables.
• Implemented sliding window for historical data archival.
• Created and implemented complex multi-step/stage ssis packages.
• Performance tuned existing stored procedures and ssis packages.

SQL Developer/DBA

Confidential, Los Angeles

Responsibilities:

• Developed complex stored procedures and scripts to generate statistics from foreign currency trading quotes and orders as per customer specifications.
• Implement SSIS packages to import quotes and orders in to database and run statistics code against quotes and orders.
• Wrote statistics output to tables for formatting and reporting.
• Assist with business requirements definition and specification, coded to the requirements spec.
• Managed database development project and worked with other developers to ensure accurate implementation.

Confidential, Santa Monica, Ca

SQL Developer/DBA

Responsibilities:

• Planned and performed SQL 2000 to 2005/2008 upgrade/migration and consolidation using, backups and transaction logs to minimize downtime and data loss.
• Created SSIS packages backup scripts, stored procedures to backup databases and compress and archive backups. Performance tuning and code rewrite and optimization .Database maintenance operations
• Created SSIS packages to develop customized database maintenance plans. SSIS for importing and transforming data in to staging and production tables.
• Developed new stored procedures for application and optimized existing ones for both high and low OLTP environment. Capacity Planning Database design and redesign where necessary.
• Migrate Sybase databases and stored procs to MySQL, adapted to SQL Server TSQL Unit test framework to Sybase ASE, wrote unit tests for Raven stored procedures using the TSQL Unit testing framework. Installed and configured MySQL databases,developed stored procedures in MySQL. Unit test MySQL stored procs.

Confidential

Developer/DBA SQL Server 2005/2008

Responsibilities:

• Member of Enterprise Security development team writing security application which monitors, detects and protects against malware (viruses), spam, spyware, filters as well as reports. Developed and wrote stored procedures, automated database installation scripts, DDL schema scripts, functions, and views for this product.
• Also developed stored procedures that automate the creation of views and aggregation stored procedures and SSIS packages that transform and xfer data from Servers to collection/reporting server. SQL Server data distribution using Replication (Snapshot and Transactional) to maintain data on different servers and remote sites.

Confidential, Burbank, Ca

DBA SQL Server 2000/2005

Responsibilities:

• Primary role as DBA for the Confidential Production Accounting Team, monitor system performance, ensure backups are completed, restore backups upon request.
• Performance tune report stored procedures, ensure proper indexing.
• Setup QA and support staging servers. Wrote DOS/2000 scripts and stored procs to automate restoring backups from Production server onto support servers. Developed automated schema modification/upgrade scripts to support new builds which Include fixes, enhancements and new features.
• Developed stored procedures and DTS Packages to automate manual processes. Implement and maintain SQL Server Replication, SQL 2005 Mirroring and SQL Clustering for High Availability.
• Upgrade and consolidate SQL 2000 Servers on to SQL 2005 using Snapshot and Transactional Replication to xfer data minimize down time (transaction loss) SQL Server Consolidation to multiple Instances on fewer servers.

Confidential, Calabasas, Ca

Developer SQL Server 2000

Responsibilities:

• Designed, developed, created and modified stored procedures, tables and objects for new features and enhancements to existing Fraud Detection System software (AFS).
• Integrated other vendors ( Confidential ) software to existing system.
• Documented all work, created release notes, assisted QA with developing test plans.
• Worked with upper management to develop technical specifications from business requirements for projects.

Confidential, Los Angeles, CA

DBA/Developer SQL Server 2000

Responsibilities:

• Designed, developed and created stored procedures to meet the internal business reporting requirements, and management of the loan pipeline.
• Designed and modified database table structure as necessary, created DTS packages.
• Implemented all modifications using strict release management procedures.

Confidential, Los Angeles, CA

DBA/Developer SQL Server 2000

Responsibilities:

• Designed, developed and created stored procedures to meet the requirements of the software development team.
• Designed and modified database table structure as necessary to support new features/functionality in applications.
• Migrated data from Alumni database to the new database structure, mapped all fields, normalized data, created Cursors and stored procedures to accomplish this migration.
• Created DTS packages for importing and uploading s tudent’s records, faculty and course data.
• Physical and logical database design and implementation.