Sql Server C#

Resume

Objective:

Data Management Lead with over 16 years IT experience, including more than 7 years as a developer in technical industry. Proficient in SQL Server 2000 to 2019, Oracle 9i to 12c, PL/SQL, ASP, .Net, C# and Visual Basic; possess strong communication and problem solving skills developed through a variety of projects. Offer proven ability in team leadership and proactive systems support.

Technical Skills:

Programming Languages:

Visual Basic 6.0, C, C++, Java, C#, ASP, ASP.Net

Web Technologies/Systems:

HTML, ASP, VBScript, Microsoft Front Page 2000, Macromedia Flash 5.0

Database Technologies / Systems:

Oracle 9i to 12C, Microsoft SQL Server 2000 to 2014, MySQL, MSBI Stack, Data Warehousing, Data Mart, SharePoint 2010, Aurora Datamining process

Operating Systems:

Windows 9x/NT/2000, UNIX

Other:

Visual Fox- Pro, UML, OOP, OpenGL, Prolog, LISP, XML, COM, Dreamweaver, TCP/IP, MS Visio, ADO, Visual Interdev, Crystal Report (8.5 & 10), Visual Age,.Net, VB.Net, PHP,, T-SQL

Certification

Oracle (9i-12C) DBA, MCITP(SQL Server 2000 -2016 DBA and Developer), PeopleSoft(In Progress)

Experiences:

ENI Petroleum (August 2008 to Present)

Sr. DBA / Developer

Provide support to various database system including SQL 2005-2019 and Oracle 9i to 19c along with PostgreSQL Database. Provide support to security and disaster recovery process for organization. Create project plan and implementation process from development to production with the plan and documentations. Implement the best practice of user access and support for the database system. Provide support to create data warehouse system for data storage as well as SQL Business intelligence for reporting and ETL processes.

Create Database security process and standardization for the organization.

Work with BI tool and help migrate SSRS reports in Power BI dashboard.

Manage data transfer with ETL in SQL from non SQL Product sources such as SAP, workday, ERP systems, and data loading system.

Helped and support integration of Skype system in database as well as SSRS.

Helped support Mongodb for the company and helped to migrate Mongodb data to Oracle based database system.

Deployed and managed database to Azure SQL and AWS cloud system.

Data encryption and Load balancing with replication for the data.

Architect and supported Azure system for database migration, automation (devops), and operations.

Manage and support HADR system with Log Shipping, Database Mirroring, and Always on.

Help support SAP part for the data migration and manage for the finance and accounting system.

Supported database tuning for application support and performance improvement.

Worked with Cognos (version 10) to create data modeling and reporting for accounting system.

Helped migrated data and creation of database on AWS system for applications.

Help Migrate database system from SQL 2012 and SQL 2014 to SQL 2019.

Provide migration help for reporting and DW system from SQL 2014 to SQL 2019

Provide support with optimization and Tuning of SQL and Oracle Database System

Support Migration of DW to Azure cloud with Polybase process and SQL Migration process

Develop and Maintain database Architecture, design, and development

Support ETL support for data transfer process between various sources.

Data analysis with SSIS, SSAS, SSRS, cognos and other BI and analytics tools.

Spectra Energy (April 2007 to August, 2008)

Business Intelligence Administrator / Sr. Database Administrator

Lead the Data team through requirements, design and development for a complete overhaul of the Business Intelligence system at an Oil and gas company. Responsibilities throughout the full life cycle included data architecture design, logical and physical data model creation, requirements gathering and analysis for reporting and operational capabilities. Provided support to implementing Data Warehouse / Business Intelligence solutions and utilizing an extensive portfolio of experience and best practices. Responsibilities included conducting technical needs of reporting architecture, data warehousing, Data transfer, and serving as a subject matter expert in business intelligence concepts. Created and maintained company wide Business intelligence environment including SSIS, SSAS, SSRS, and SQL server 2005and 2008.

Helped convert Business Object report to SSRS tool of SQL server 2005 to 2008.

Provide data and schema comparison process to test against production with RedGate tool.

Create and maintain BI environment for groups and departments in company.

Configure Replication, Log Shipping, and Failover clustering to meet customer needs for

Production environment to development environment.

Provided support for Reporting services such as Analysis Cube Processing, Reporting services Pro-Clarity.

Supported ETL process of the company to provide better business model and structure of database system.

Supported team with expert needs of creating and maintained company wide reporting structure in SSRS.

Implemented system where internal and external users can access reports from SSRS environment.

Applied security for users to access Dashboard and reports.

Environment Used: SQL Server 2000,2005 and 2008, SSIS, SSAS, SSRS, Data warehousing, Data Modeling.

The Planet (May 2006 to Apr 2007)

Sr. Database Administrator / BI Administrator / Developer

Lead the Data team through requirements, design and development for a complete overhaul of the Business Intelligence system at company. Lead the team of DBA and Developer to provide maintenance support and installed more than 20 instances SQL servers. Supported migration from 2000 to 2008 SQL server environments. Performed all aspects of database administrator, Database Mirroring, including data modeling, backup, recovery, Disaster Recovery, OLAP processing for Analysis services, and replication. Create BI environment and provide support to developers and users requirements. Help testing SQL server 2008 for future migration process and define process and document for reference during transformation from 2005 to 2008.

Work closely with application developers and business users to design databases

Create and maintain BI environment for groups and departments in company.

Configure Replication, Log Shipping, and Failover clustering to meet customer needs for

Production environment to development environment.

Provided support for Reporting services such as Analysis Cube Processing, Reporting services Pro-Clarity.

Provided support managing MySql system and setting up bin log process for DR system

Lead a team of database developers in the extraction, transformation, and load process from of a different file base system to SQL base such as Access, Oracle, Excel, and flat files.

Convert customer requirements into logical and physical database designs and models.

Help testing new SQL 2008 CTP for future migration from SQL 2005.

Create, modify, and maintain written documentation and modify existing stored procedures, triggers, and views.

Environment: SQL Server 2000,2005 and 2008, Oracle 8i, 9i, & 10g, SSRS,SSIS,SSAS.

Home123(New Century Financial Corp) (September 2005 to May 2006)

Database Administrator / Developer

Database Administration experience as a Production and Development DBA. Data Analysis: Architecting corporate data migrating through transaction systems, OLTP and OLAP systems, Data Warehouse systems into archival systems. Database Design: Data Modeling and design. Database Design for referential integrity and performance. Development of Business rules implemented as Constraints, Triggers and or Stored Procedures. Experienced with EDI and markup languages. Routine DBA activities: Backup and Data recovery, Data security, Data Migration, Performance Tuning, Capacity Planning, DBMS monitoring, Data Integrity analysis, User Management, and Log Analysis.

Work closely with application developers and business users to design databases

Design databases using Visio and Erwin at the ORM, logical and physical level.

Implementation Batch processing Performance monitoring and tuning SQL Trace / SQL Tuning Oracle Logminer Process automation.

Oracle Fail Safe (High Availability) implementation and support Database replication Data cleansing, extraction and monitoring SQL Programming PL/SQL Programming Backup plans.

Supporting Oracle 9i database system and optimizing the requirement of the system.

Convert customer requirements into logical and physical database designs and models.

Environment: SQL Server 2000 and 2005, Oracle 8i & 9i, VB, ASP, ASP.Net, .Net

Gyrodata Inc., (November 2002 to September 2005)

Database Administrator / Developer

Installed new MS SQL Server 2000 and maintained 10 to 15 servers. Performed all aspect of database administrator, including data modeling, backup, recovery, and replication. Additionally designed and implemented disaster recovery system. Designed and executing Database Transformation Services(DTS). Wrote Stored procedure and T-SQL code, as well as VB and ASP codes. Also helped develop application and coding in C# environment.

Monitor MS SQL servers for errors and performance degradation.

Creating Stored Procedure in T-SQL, Cursor, and Triggers for database functionalities.

Upgrade existing MS SQL Server software to newer versions and/or Service Pack Levels.

Set up alerts, operators, SQL Mail, SQL Agent Mail, and notifications.

Configure Replication, Log Shipping, and Failover clustering to meet customer needs for production environment to development environment.

Define Disaster Recovery and Backup Strategy.

Helped Developer team in coding with C# and converting COM object to C# level.

Performed Project lead for job tracking application developed in C#, ASP.Net, and backend with SQL 2000.

Environment: SQL Server 2000 and 2005, Oracle 8i & 9i, VB, ASP, ASP.Net, .Net,C#, C++, COM

Aramark Food Services, (July 2002 to November 2002)

Application Developer

Responsible for Team co-ordination for the project and delivery of the project. Built web-based applications in ASP, which involved a Search application, Report builder using Crystal Report 8.5 utilities. Wrote Stored procedure and triggers in SQL 2000 for better performance of large query in application. Also created web based reporting application using java, Crystal Report, ASP, and SQL 2000.

Educational Background:

University Of Houston, Houston, Texas.

MBA in Technology Management (TM & PM) (December, 2010, GPA 3.69) from University of Phoenix

BS in Computer Science (December, 2001, GPA 3.25) from University of Houston

Personal Strengths:

Highly organized and dedicated, with positive attitude.

Able to handle multiple assignments under high pressure and consistently meet tight deadlines.

Thrive on working in a challenging environment.

Able to work in team and individual.

Contact this candidate