Sql Server Developer

Moise Soumbey-Alley 407-***-****

********@*****.***

***** **** ****** *** *******, TX 78230

PROFESSIONAL SUMMARY

. Over 15 years of IT in general

. Over 10 years' experience with SQL SERVER Database Administration, System

Analysis, Design, and Development & Support in Production, Replication

and Mirroring Environments.

. Experience with Oracle Database to 11g and MySQL Database

. Expertise in planning and implementing MS SQL server security and

database permissions

. Experience in Database Backup, Recovery and Disaster Recovery procedures.

. Experience in installation and configuration of MS SQL Server 2008

R2/2005/2000 versions.

. Experience in Migration from SQL Server 2000 to SQL Server 2005/2008 R2

and Oracle 10g as well as DTS Exchange tool for migrating DTS packages to

SSIS packages.

. Experience in migration of Data from Excel, Flat file, Oracle to MS SQL

Server by using BCP (Bulk Copy Program) and DTS utility. Extracting,

Transforming and loading of data using SQL Server DTS.

. Installing SQL Server in a Cluster Environment.

. Experience with upgrades and service pack installations Tuning and

normalization.

. High level proficiency with various types of Replication Models such as

Snapshot, Transactional and Merge Replication (Planning, Replication

Tools, Implementing Replication).

. Extensive experience in Capacity planning, Maintenance planning,

Performance Tuning.

. Proficient in monitoring SQL Server Performance using SQL Profiler (Dead

Locks/Long running queries), Query Analyzer, Index Tuning Wizard,

Database Engine Tuning Wizard and Windows Performance Monitor.

. Hands on experience and outstanding knowledge in high availability

solutions, including SQL Server clustering, replication, Log shipping,

and Mirroring.

. Managed the multiple databases (DB) under clustered (active/active,

active/passive) and implementing RAID technology.

. Experience working with Windows 2008 R2 Datacenter, Windows 2008 R2

Enterprise, Windows Server 2008 Datacenter, Windows 2008 Enterprise,

Window 2003 Enterprise Server and Windows 2000 Advanced Server

Administration and Installation

. Experience in Extraction Transformations and Loading (ETL) tools like

Data Transformation Services (DTS), Bulk Insert, and BCP for OLTP and DSS

(Data Mart/Data Warehouse) environment.

. Knowledge of business intelligence/data warehousing practices and tools

using MS SQL Server 2005 Reporting Services (SSRS).

. Experience in SQL Server Reporting Services (SSRS) Installation and

Configuration for Scale-Up and Scale-Out topology

. Strong SQL Server Administration skills using various backup strategies,

Model (simple, bulk and full), database maintenance plan, user (NT/SQL)

security authorizations, database creation.

. Very good hands on experience with DB Artisan admin, ERWIN 7.1, Microsoft

VISIO tool and SQL Assistant tool.

. In depth knowledge of developing complex stored procedures, views,

efficient triggers, required functions, and creating indexes and indexed

views using SSMS and SQLCMD.

. Created and managed schema objects such as tables, views, clusters,

indexes, procedures and triggers through query analyzer

. Involved in optimizing code and improving efficiency in databases

including re-indexing, updating statistics, recompiling stored procedures

and performing other maintenance tasks.

. Managed day-to-day User activities like creating logins, granting

permissions, applying security for new users and creating user Roles and

Role Members to ensure Security.

. Supported the deployment of SQL Server 2005/2008, SSAS (Analysis

Service), SSRS (Reporting Service) and SSIS (Integration Service for ETL

activities).

. Experience with ER-win data modeler for generating physical and logical

schemas. Generating DDLs scripts and Forward and Reverse Engineering

Databases.

. Experience creating InfoPath forms and deploy them with SharePoint

. Self-motivated and Flexible to adapt to any new environment and work on

any project.

. Worked as a team member to provide 24x7 on-call production database

support.

TECHNICAL SKILLS

Relational Databases : SQL Server 2012, 2008 R2/2005 / 2000 / 7.0, MS-

Access 2000/2003/2007,

Oracle 9i & 10g, My SQL

Database Tools : SQL Server Enterprise Manager, Query Analyzer, SQL

Profiler, SSIS,

SSAS, SSRS, DTS, BCP, ODBC, SQL OLEDB, DBCC,

ADO, ADO.NET, Business Intelligence Studio,

InfoPath, Access Form, Crystal Reports, Oracle

old forms and reports.

Languages : T-SQL, C, VB.NET, ASP.NET, ColdFusion, XML, Batch

Scripting, Unix

Oracle SQL and PL/SQL, HTML, Java Script

Operating Systems : Windows 2008 R2, Windows 2003, Windows 2000

server, Linux

Web Servers : IIS 5.0/6.0, Apache

Architecture : Relational DBMS, Client-Server Architecture,

Clustering, Replication,

OLTP, OLAP

ETL : SSIS, DTS, Data Stage, San Technologies

: Erwin 4.0/3.5, Microsoft Visual Studio 2003/2005/2008, Service

Center,

Other Tools : VMware, MS

SourceSafe, Source Control, MS Visio,

Windows System Monitor, SQL COMPARE, SAP Basis

EDUCATION

. Bachelor in Information Technology (Clayton College & State University)

. Microsoft Certified Technology Specialist (SQL Server DBA MC ID:

10605512)

. CompTIA Security+ Certified (COMP0010206643163)

PROFESSIONAL EXPERIENCE

HP (Hewlett-Packard) San Antonio, TX September

2013 - To now

Sr SQL Server DBA/Developer

HP is one of the biggest contracting companies in USA, especially

government contracting jobs.

I was hired to work as senior SQL server DBA/Developer as well as some

oracle DBA work.

I work on several US Department of Defense projects.

Responsibilities:

. Migrated Databases, DTS packages, from SQL Server 2000 to SQL Server

2008.

. Administered the SQL server 2000/2005/2008 by creating user logins,

dropping and locking the logins, monitoring the user accounts, creating

groups, granting privileges to users and groups.

. Developed DTS and SSIS packages to extract, transform and load (ETL) data

using SQL Server 2008 Integration Services and successfully completed DTS

to SSIS conversion

. Used Extraction Transformations and Loading (ETL) tools like Data

Transformation Services (DTS), Bulk Insert, and BCP for OLTP and DSS

(Data Mart/Data Warehouse) environment.

. Worked on business intelligence/data warehousing practices and tools

using MS SQL Server 2005 Reporting Services (SSRS).

. Designing and creation of tables, stored procedures and triggers.

. Create complex InfoPath Forms that query and insert data in SQL server

tables.

. Create complex Access Forms that query and insert data in different

tables for the staff attendance tracking.

Florida Realtors, Orlando, FL

October 1999 - September 2013

Sr SQL Server DBA/Developer

Florida Realtors is the largest trade association in the state with more

than 118,000 members, and the second largest Realtors Association in the

country. The company has numerous SQL server and Oracle databases, and also

has many web sites use by members and non-member for their real estate

transactions.

Responsibilities:

. Perform daily production server check: verifying SQL backups, Disk space,

Job failures, system checks, checking performance statistics for all

servers using monitoring tool and research and resolve any issues,

checking connectivity i.e. log into customer application\billing

application to ensure it can connect to databases, checking replication

on each server by checking each publication to make sure the distributor

is running for each subscription, Using Central Desktop to document any

issues and how they were resolved.

. Successfully upgraded from SQL Server 2000 to SQL Server 2005 and then to

2008 R2 in Development and Production Environments.

. Installed and configured in clustering environment for SQL server 2008

ENT for 2 node configuration

. Upgraded Servers from SQL server 2000 to SQL server 2008 and installed

service pack

. Involved in SAN migration, completely moving data centers, changing the

storage backbend's to different vendors, consolidating SANS.

. Installed and configured SQL server 2008 and administered.

. Prepared and documented database Backup, Recovering and Maintenance

Plans.

. Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered

Indexes, Views, Functions and Stored Procedures.

. Involved in general Database administration, query performance tuning and

validated some of the existing schemas

. Responsible for maintaining all database environments Development,

Testing, QA, Staging, and Production.

. Administering SQL Server security and apply security across environments

and trouble shoot security issues on daily basis.

. Successfully implemented Database Mirroring with High Availability Mode

in SQL 2005.

. Implemented Log Shipping in SQL 2005 from Primary Server to Standby

Server.

. User management by assigning appropriate permissions to the database

users.

. Experience in upgrading SQL Server and applying service packs and hot

fixes and unattended Installations.

. Experience in handling the situations in change control process.

. Involved in database administration tasks and assisting developers with

problems with SQL optimization, tuning and SQL Profiler

. Monitored, Scheduled jobs and alerts and did troubleshooting when failed

on daily basis.

. Experienced working on SQL COMPARE tool to compare the structures between

databases in order to synch them

. Expertise in Setting up database backup and recovery procedures for

production, QA and development servers.

. Installing SQL server 2008 in windows Cluster environment.

. Worked on SQL Server Clusters Active - Passive on mission critical online

forms and financial applications.

. Development an automatic daily, weekly and monthly system maintenance

tasks such as database backup, database mirroring, replication

verification, database integrity verification and indexing updates and

applies in development and testing environment.

. Set up and manage database security by creating new users, roles,

profiles, and provide required user privileges, testing, training in

production environments.

. Responsibility also includes development, maintenance, performance

analysis, and support software applications not only for internal users

and also for our web applications and using tools like crystal report,

report writer, and programming language such as SQL, T-SQL, PL/SQL,

JavaScript, PHP, ColdFusion, and some PowerShell.

. Experience with Dropping and recreate the tables for the damaged

databases to avoid data loss.

. Refresh the database from production to development and staging

environment on daily basis.

. Involved in the Backup & Restore and point in time recovery of the

databases.

. Created drill down, sub reports using MS SSRS 2008 as well as managing

the deployment of the reports.

. Responsible for developing, monitoring and deploying SSIS packages.

. Loaded data from various sources like flat files, to SQL Server database

Using SSIS Package.

. Configured SQL mail agent for sending automatic emails when a SSIS

packages is failed or succeed

. Troubleshoot system issues, monitored scheduled jobs and set up

maintenance plans for proactively monitoring the performance of SQL

Server databases.

. Involved in the Query optimization and Performance tuning, and also tuned

SQL queries using Show plans and Execution plans.

. Write SQL views against source tables in Oracle with business rules

applied.

. Created permanent tables, temporary tables and table variables.

. Conducted design reviews with users/team for development and production

strategies.

. Translating business requirements into technical design specifications

and actively supported business users for change requests.

. iMIS software administration responsible for data structures and expert

in creating complex T-SQL queries, procedures, functions, Triggers,

reports and more.

. Involved in setting up and testing disaster recovery center in

Philadelphia in 2008

. Capacity-planning, Maintaining run book documentation on all the servers

in word, pdf and excel formats.

. On call (night time and weekends) support to databases on weekly

rotation.

Environment: SQL Server 2012, 2008 R2/2005/2000, Windows 2003\2008

64bit\32bit, Oracle 10g, Oracle Forms and Reports, Crystal Report, Red Hat

Linux, SQL backup5 Red Gate, SQL secure, ETL, SSIS, SSRS, C#.,

VB,ASP.NET,SSAS, System Monitor/ Performance Monitor, VMware ESX, Share

point 2007, Microsoft Dynamics.

Visiontek Software Inc, Norcross GA

January 1998 - June 1999

Developer /DBA

Visiontek Software was a consulting company specialized in setting up

Oracle database and Oracle application to various companies;

Responsibilities:

. Migration of MS SQL Server 6.5/7 to an oracle database.

. Work with a team of developers in an application developed for rental

companies.

. Capture customer information as well as the companies billing and

invoicing procedures.

. Develop about fifty Forms using oracle Developer/ 2000, Forms 5.0 to

meet some of the application's request.

. Using some built-in procedures to call about ten reports created using

Oracle tool Report 3.0, to properly inform the Users.

. Designing and creation of tables and stored procedures.

. Created and maintained various databases for development and testing

environment.

. Testing the stored procedures and packages written in collaboration

with fellow programmers to make sure they execute as designed.

. In addition to testing the Stored Procedures and Packages written in

PL/SQL language, I also wrote

some database Triggers, to

enforce some of the business rules as well as data security.

For instance to keep an audit of users who logon to the application

and control users access to different modules of the application.

. Writing some Packages in PL/SQL language to efficiently organize some

of the application related objects, as well as grant privileges.

. Maintained application Schemas found during testing that were not

performing as intended, for example, an Open Form trigger that should

fire when the right button is pressed failed.

Environment: MS SQL Server 6.5/7, Oracle Database, Developer/2000(Forms

(3.0, 4.5, 5.0), Report (2.5, 3.0), UNIX, SQL, PLSQL, JavaScript, Excel,

Crystal Report.

Guru Software Services, Atlanta, Georgia June

1997 - December 1997

Oracle Application Developer (Intern)

Guru Software Services was a learning center as well as a consulting

company.

Responsibilities:

. Worked as Intern/Trainee on some rigorous high quality projects that

involved intensive training in SQL and PL/SQL, Entity Relationship

Modeling, and Function Modeling using Forms, Reports and Graphics.

. Finished a project developing an Application that involved SDLC which

used Oracle on the back-end and front-end in an NT platform

environment.

. Hands on experience in trouble shooting database issues. Update

statistics, database integrity check and Backup operations

. Created and populated Database Tables using SQL Data Definition, Data

Manipulation, and Data Control languages.

. Wrote Triggers at form level, block level and item level to control

and secure Data access.

. Wrote Stored Procedures and Packages in PL/SQL to perform various

functions.

Environment: Oracle and SQL Server Databases, Developer/2000(Forms (3.0,

4.5, 5.0), Report (2.5, 3.0), UNIX, SQL, PLSQL, JavaScript, Excel,

Crystal Report.

Other:

Have security clearance

Bilingual (French/English)

Contact this candidate