We provide IT Staff Augmentation Services!

Sql Server Dba/developer Resume

UsA

Summary:
Offers twelve years of experience in all areas of the software engineering lifecycle, including requirements, analysis, design, prototype, build, documentation, testing, quality, production, and support. Possesses ten+ years of experience in Data Architecture, OLTP and OLAP Database Modeling, Database Administration, Development, Data Warehouse, Data Integration and Business Intelligence. Bilingual: English and Spanish.
Te chnical Skills SQL Server 2014 E/R Studio/Erwin Modeling Database Administration Index Management SQL Server 2012 Process Modeling Database Partitioning OLTP/OLAP SQL Server 2008R2 Kimball/Inmon DW Modeling Data Replication Idera,RedGate,Sentry SQL Server 2005 Data Warehouse/DataMart/BI Database Log Shipping Waterfall/Agile T-SQL/PL-SQL Data Architecture Database Performance SSMS,SSIS,SSAS Data Integration MDM/Data Governance DB2/Oracle 9i
Selected Projects
Confidential,USA
SQL Server DBA/Developer

Data Warehouse/DBA Project to build Sales, Marketing and Financial Data Marts for Leasing Industry.

  • Transactional environments with 1 billion records and 1TB Databases
  • Administered 25 SQL Servers 2000, 2005, 2008 Enterprise/Standard Edition in Production, Preproduction, Test and Development Environments on Windows 2003 and 2008.
  • Migrated, installed, upgraded and patched SQL Server 2000 to 2005 and to 2008R2.
  • Monitored Error Logs, Windows Logs, Database and Logs space utilization, Drive Space availability, Running Services, Replication and Job history from SQL Server Agent.
  • Performed DB Backup full, differential, transactional log and Restore DB’s point in time.
  • Established Backup strategy 4weeks online storage Point to Point Restore and 4 weeks offline.
  • Manage DB Change management by keeping history of db deployment and rollback scripts.
  • Optimized SQL server performance on CPU, Memory, Network, Disk, Index Management, T-SQL, TempDB, Execution Plans, and Waits Monitoring.
  • Used of DMV, DMF, DTA, Quest Optimizer, SQL Sentry, Idera, Redgate for administration.
  • Performed Security tasks to manage logins, users and assign permissions.
  • Wrote T-SQL 2000/2005/2008 on financial foreign exchange OLTP main databases containing around 400 tables, 800 stored procedure, and 100 functions.
  • Normalized and de-normalized to achieve query optimization to < 1sec response on 1TB Database..
  • Designed Staging and DW using star-schema model to support SSAS BI project.
  • Wrote SSIS 2005/2008 packages for DW ETL process between OLTP and OLAP DB.
  • Loaded 200M records through WAN in 2hrs optimizing SSIS performance.Database Architecture and Production Database Administration project for Aviation Industry.
  • Built new Database Architecture to support Production, QA and Development environments on SQL Server 2008R2 platform
  • Consolidated 25 dispersed SQL Server 2000 and 2005 Instances into 15 new instances for Production, QA and Development for the Database Engine, SSIS, SSRS and SSAS engines.
  • Consolidated Databases, Jobs, SSIS packages, SSRS reports and subscriptions,
  • Wrote SSIS 2005/2008 packages and stored procedures to support database administration, job history, find windows services status.
Data Architecture Customer Data Hub Integration for Hospitality Industry.
  • Discovered Business process of current Customer maintenance.
  • Redesigned Business Process to build Customer Data HubData Architected E/R Data models of the new Customer Enterprise Data Hub application that worked as a transaction broker that synchronized Customer Information.
  • Read Data Requirements to Load Data in to Oracle Database
  • Understood Data Models to map with Data Requirements and Data Sources. Participated in Master Data Management and Data Governance initiatives.
  • Prepared Oracle Scripts to populate Master Data.
  • Used Toad for Data Analyst to Model, Query and Report.
  • Managed Databases version for Master Data.
  • Data Quality Assurance before build deployments. Aero Turbine, Database Architecture/SQL Server DBA (Contract) December 2011– February 2012 Migrated 15 Database SQL 2005 Servers to SQL 2008 R2.
  • Refactored SSIS packages to load Data Warehouse.
  • Migrated SSRS 2005 reports to SSRS 2008.
  • Consolidated Database Servers into a Virtual Environment.
  • Architected new Database Infrastructure following Microsoft Best Practices document.
  • Organized database environments to follow SDLC in Development, Test, UAT and Production.
Confidential
SQL Server DBA/Developer
  • Administered 25 SQL Server 2000, 2005, 2008 Enterprise/Standard Edition in Production, Preproduction, Test and Development Environments on Windows 2003 and 2008 Enterprise Edition.
  • Worked on migration project by installing, upgrading and patching SQL Server 2000 to 2005 and to 2008R2.
  • Monitored SQL Server Error Logs, Windows Logs, Database and Logs space utilization, Drive Space availability, Running Services and Job history from SQL Server Agent.
  • Performed DB Backup full, differential, transactional log and Restore DB’s point in time.
  • Manage DB Change management by keeping history of db deployment and rollback scripts.
  • Optimized SQL server performance by applying best practices around CPU, Memory, Network, Disk, Index Management, T-SQL, Temp DB, Execution Plans, Waits Monitoring.
  • Used of DMV, DMF, DTA, Quest Optimizer, SQL Sentry, Idera, Redgate tools to support administration.
  • Performed Security tasks like create, enable, disable logins and users, assign permissions to users/resources.
  • Developed T-SQL Stored procedures, Functions, DML, DDL scripts to support fnancial OLTP applications on multiple environments like dev, test, QA and production on SQL Server 2000, 2005, 2008 and 2008 R2 versions.
  • Wrote SSIS packages and BCP for ETL jobs and DW processes.
  • Build Transactional Replication to keep updated multiple development environments
  • Query optimization, DTA, Profiler, Execution Plans, Client Statistics, Index management, Partitioning, Linked Servers, Jobs, User Administration, and Performance Monitor.
  • Data Modeling, Data Integrity, Data Domains, Normalization, De-Normalization.
Confidential
SQL Server DW DBA/Developer
  • Developed multiple T-SQL store procedures, functions, DML, DDL scripts to support DW applications.
  • Maintained ER Model using ER/Studio.
  • Wrote SSIS packages for ETL processes.
  • Established transactional replication across multiple production servers.
  • Monitored Jobs running every day in 15 production servers (SQL Server 2000, 2005, 2008)
  • Utilize SQL Sentry to create chained jobs that run under the daily window maintenance
  • Query optimization, DTA, Profiler, Execution Plans, Index management, Partitioning, Linked Servers, and Jobs.
Confidential
Oracle Data Architecture Analyst
  • Designed Process and Data Model for a Customer Enterprise Data Hub with E/A Studio and E/R Studio.
  • Designed a Data Model to store company technology resources and assets.
  • Wrote Oracle PL/SQL and Sql Server T-SQL store procedures to handle ETL processes.
Confidential
Modeler/Database Senior Designer
  • Worked as designer in the Enterprise ODS concepts to support Data Marts. Specific tasks were identification of data sources, construct data decomposition grids, data flow diagrams, database design, data mappings, data integration and data migration strategies.
  • Worked as designer of conceptual and logical models of the Physical Room Inventory and Reservation Enterprise database models using E/R Studio. Specific tasks were identification of data sources, construct data decomposition grids, data flow diagrams, database design, data mappings, data integration and data migration strategies. Physical Database implementation will be done in SQL Server 2005.
  • Defined the data migration strategy from Legacy Systems to Enterprise Physical Room database model.
  • Designed conceptual, logical and physical Enterprise database model of an application that propagates reservations among multiple source/targets. It improved the processing 10 times compared with older version
  • Managed a development data team as a data lead in areas of database modeling (E/R Studio), physical model (SQL Server 2000/2005) implementation, ETL and SSIS processes, data schema synchronization (Red Gate), data synchronization (Red Gate), data cleansing (T-SQL), store procedures, functions, indexing.
  • Established log shipping strategy between db’s at resorts with headquarters office central db’s for high availability strategy. Mirrored Central Reservation database for Reporting Services. Established replication strategy to make data available to third party applications access.
  • Designed conceptual, logical and physical database model for a resort front desk application deployed in around 50 resorts across the nation. Average of 90 tables and 400 GB in size for all resorts. Currently working on integrating all resort databases in one centralized operational data storage that will support enterprise corporate applications. This model includes reservation, inventory, guest profile, financial schemas and more.
  • Modeled a business and data process and data model to support a service application that extract, transform and load data from resorts database into a consolidated model which is use to export data to external customers.
  • Analyzed data requirements to propagate reservations from legacy reservation systems in multiple platforms to the Enterprise Broker Delivery Agent and from there to up to 50 resorts managed by a Front Desk application. An average number of 50,000 daily reservations updates on an average of 80 tables and 600 GB of size.
  • Defined data conversion mappings among multiple legacy systems like hotel codes, room numbers, reservation numbers, and accommodation types to hospitality standards.
  • Maintained up to date data about 28,000 room units from about 150 resorts that enable the Broker Agent to propagate appropriately reservations from source to target reservation systems.
  • Wrote DDL’s to maintain database schema objects for both Oracle and SQL Server databases.

Hire Now