Objective: To obtain a challenging position that focuses in Database Administration, Performance tuning specialist, DB Architect, Data Modeling, IT manager, Team Leader.

Professional Summary:

Innovative database professional with more than 15 years of experience managing MS SQL and Sybase ASE infrastructure.Highly skilled in large commercial and financial systems architecture, distributed databases and application infrastructure, design, development, expert performance tuning, production rollouts, maintenance and support.

Expert in stored procedures, triggers, referential data integrity, CASE tools, data/process modeling, logical / physical database design.

Computer Skills :

Languages: T-SQLDeveloper, Delphi, Pascal, Perl scripts, PL/SQL, Java, Java Script, Visual BASIC, CFML, XML, C, C .

Development Environments:

• Borland Delphi v.1-7 Client/Server Suite, Oracle JDeveloper 3.2.3, Jbuilder 4, C Builder 3.0
• Operating Systems: MS Windows Server 2008, 2003, 2000, XP, Vista, NTServer 4.0

RDBMS: MS SQL Server 2000, 2005, 2008, Sybase ASE 12.5, Oracle 7.3, 8i, MySQL, Cache, Mumps, InterBase 4-6, Paradox, DBase

CASE tools: Embarcadero ERStudio, DB Architect, Erwin 4, 7

Applications: Performance Monitoring Tools: IWatch, Symantec I3, QUEST SQL Central, Spotlight, FogLight, Coefficient, SpeedLite, Toad, LECCO SQL, Embarcadero DBArtizan, SQL Sentry, Ignite, Cold Fusion Studio 4.5, Macromedia Ultradev 4, Flash, Sybase Power Designer, SQL Lab 4.5, Apache Server, MS Office 2003,2007, Corel Draw 9-12, Orion Application Server, Apache HTTP Server, MS IIS, Unix emulators Reflections and Citrix, SQL Sentry, Confio Ignite.

Other: Java applets and applications, HTML, CGI, Crystal Report, ODBC, ActiveX, DCOM, MIDAS, ADO, PC Anywhere

Work Experience :

Project Leader, Senior DBA, Contractor

• Created and implemented high availability DR scenarios for a SQL Server 2012 based on mirroring, AlwaysOn availability, clusters and Amazon cloud
• Set up monitoring repository servers for a performance monitoring and tuning with a alerts system IWatch, SQL Sentry, Confio
• SQL Server code review, best practice implementing, SP tuning
• Performed the data migrations from Sybase to SQL Server for a Prudential and Carmax
• Performance and tuning of the Sybase and SQL server engine and code
• Database migration from Sybase to SQL Server assessment tool
• Performance metrics data collector and analysis tool for Sybase servers including SQL text, stored procedures, triggers and their durations based on MDA data
• Migrated dozens of databases and hundreds of stored procedures, triggers and views with challenging to convert statements from Sybase ASE
• Testing and compare SPs results for SQL Server and Sybase environments
• Tuning existing SPs, functions and triggers for a better performance
• Leading 5 DBs and 10 developers

Senior DB Architect, Project Leader, Contractor

• Responsible for design logical and physical data models for a rights management asset system using embarcadero ER studio
• Organized SQL server migration from 2000, 2005 to 2008 and Sybase 12.5.x/15.x
• Built ER repository and portal to share ER models between business users and developers
• Monitoring performance and production SQL server issues
• DB objects code review and recommendation for developers
• Tuning existing SPs and functions for a better performance
• Migration project from Sybase to SQL server DB object migration and testing
• Designed logical and physical data models for smart messaging platform capable of transmitting hundreds of thousands of voice and text messages in minutes, receiving responses and monitoring and reporting the results
• Manage, tune, and scale SWN's SQL Server databases, across robust production, test, and staging environments.
• Administered DB replication, log shipping and mirroring with monitoring and alerts setup
• Planned and set up database SQL 2008 server cluster on windows server 2008R2
• Provided process leadership for database change management
• Mentoring and code reviewing in TSQL
• Contributed SQL and data modeling expertise to the rest of the team
• Upgraded SQL server 2000 environment to SQL server 2008
• Expertise with SQL Server 2000, 2005, 2008 database administration, monitoring, tuning, and troubleshooting
• Optimizing and partitioning SQL Server environment for reporting and BI applications
• Built three Datacenters worldwide and install SQL server on cluster environment
• Close monitoring, troubleshooting production issues and extensive performance tuning of all production SQL Servers across all data-centers

Senior DBA, Team Leader, DB Architect

• Architected and designed new logical and physical data models for an Enterprise Brokerage systems, Futures transactions, Custodian banks reconciliation system, Client Fee reporting
• Created a full cycle of Hedge Funds CUSIP creation process
• Established a performance monitoring of Sybase and MSSQL servers using IWatch, SQL Profiler and I3 tools, capacity planning infrastructure, resolved issues and problems on QA and production environments, illuminated bottleneck performance related issues
• Developed numerous stored procedures and processes, performance improvement and tuning of existing procedures
• Designed and developed Audit Log Reporting mechanism in regards to data value modifications
• Supervised a group of six DBAs, QAs, developers for a different DB related projects
• Created Permissions Monitoring process to keep track of objects permission for all changes and rollouts in existing databases created a data-audit history for the client performance DB and security audit for schemas and roles
• Tuning server software and hardware, SQL server parameters and client part of MSSQL for maximum performance, resolving replication problems
• Developed daily DB maintenance processes and disaster recovery plans, log shipping strategies and DB mirroring
• Installation new instances, upgrading and migrating existing DBs, projects and dataflow to SQL servers 2005 and 2008
• Database Server Monitoring and Performance Tuning
• Establishment and maintenance of DB backup/restore/recovery processes and procedures for electronic trading
• Responsible for installing, configuring and managing busy clustering environment
• SQL server Replication, Log shipping, administration and troubleshooting
• Administration of database middleware software, processes, jobs and procedures
• Database software installation, upgrade and configuration for trading system
• MSSQL 2008, 2005, 2000, Sybase 12.5 ASE, IWatch, Symantec I3, Red-gate tools, Erwin, Embarcadero DBArtizan, ERStudio, Microsoft Project, MS Performance tools, DTA, Profiler, SSIS, Cristal Report
• Created ETL packages to import and export data using SSIS to interact with a various data sources
• Support Application, Development, Windows Server and UNIX Administration Teams regarding Database issues
• Created and maintained cluster environments 2 nodes active/passive, active/active
• Work with developers on new development projects and systems
• Problem resolution, reporting and tracking, backup and recovery strategies for production and QA environment
• 24x7 production support in a highly active financial environment, bonds, foreign exchange and equities market
• Capacity planning, alert and jobs setup and migration

MSSQL 2000, 2005, Sybase, SSIS, Quest Spotlight, Foglight, LiteSpeed, Toad, Embarcadero DBArtizan, ERStudio

Senior DBA, Team Leader,

• Team Leader of four QA, system admin and 2 junior DBAs
• Planning Disaster Recovery Plan for Databases, Emergency recovery of system DB
• Responsible for design, creation, administration and maintenance MS SQL 2000, 2005, Oracle 8i and MySQL databases with medical necessity information
• Responsibilities divided into: DBA work 30 , Management 20 , Development 20 ,
• Data Modeling, normalization and advance T-SQL Stored Procedures development
• Designed ER DB models and DB schemas, created internal logic, tables, view, procedures, functions, cursors and triggers on new and existing databases
• Created mechanism to update MSSQL data on a monthly basis from Oracle and MySQL
• Implemented snapshot, transactional, merge replication and log shipping for our clients
• Performance monitoring and optimization for production, QA, development and clients DB including troubleshooting and solutions
• DB and procedures monitoring and tuning using Quest Spotlight and Foglight software, Profiler and Index tuning Wizard
• Support for DB servers which includes installing, upgrading database software, SQL Server Service Packs and Security patches, updating Windows Servers 2000, 2003
• Back Up and Restore DB on a regular basis
• Using DTS, BCP and other utilities to prepare data for a clients structure and data transfer from MSSQL into MSSQL, Oracle and MySQL DB
• Perform multiple instance failover clusters and network load balancing using SAN
• Created hardware solution for a new database related projects
• Developed client parts on Delphi using multi-tier technology to transform coding data, government policies and medical knowledge into timely, actionable, enterprise-wide information
• Created programs to send a data to UNIX terminal emulators such as Reflections, and Citrix for updating mainframe database

MSSQL 2000, 2005, Oracle 8i, MySQL 3,4, Cache, Mumps, SQL,Delphi 6,7, Quest LECCO, Embarcadero ERStudio 5, Erwin, DTS, MS IIS

Senior DBA

• Created FuelCenter project which is Internet/Intranet based information system designed to collect aviation fuel inventory and fuel transaction information from multiple locations using Internet communication technology and to prepare and represent necessary reports and invoices for fuel companies
• Responsible for creation, administration and maintenance MSSQL 2000 and Oracle 8i databases, stored procedures, development client parts and Web site for access to FuelCenter database
• Delphi 5, Jbuilder 4, MSSQL 2000,Oracle 8i, Cold Fusion 4.5, Toad 6.5, Sybase PowerDesigner, Java applets

DBA developer, senior programmer

• centralizing business logic and client applications
• data sharing and communication within local-area network
• Responsible for design, development and integration of multi-tiered client/server database applications, using DCOM, which provides the following:
• data modeling and relational database design
• Development of programs and DB objects for monthly statistic reports for Oracle, MSSQL, Interbase SQL Servers balance due, traffic calculation, number of telephone conversation, etc.
• team programming Delphi, MSSQL, Oracle, Cache, Mumps, Paradox, PowerDesigner
• maintenance of the software, responsible for money collection for telephone services
• Designed, developed and maintenance an application which created reports in MS Office, Quick Report using ODBC, IDAPI interfaces or OLE-Automation to gain access to MS database products or an Oracle server
• Designed local and long-distance phone network automation on Oracle DBMS
• Assembling, installation, service and support of business machines accessories
• Development support of inventory-making and accounting programs for small businesses
• Delphi, Interbase, Oracle, Sybase SQL, Paradox
• LAN network installation and servicing
• daily functions local TCP/IP network,15-20 users
• Development programs for automation of public telephone services
• project leader Borland C , Delphi, Visual Basic, Assembler