Sql Server Sales

De Juan Lewis

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

Ph:678-***-****

Objective

________________________________________

Junior to mid- level SQL Server Data Base Administrator /Developer.

Summary

• ________________________________________

Total 2 1/2 + yrs of SQL 2008 r2 Administration experience in IT.

• Have good knowledge in MOF Architecture and experience in an operation environment providing support involving coordination with release management and change management.

• Experience in Migration from sql server 2005 to 2008 r2.

• Experience in MS-SQL Server Administration including Design and implementation of Replicated Databases, planning/ implementing backup/ recovery strategies, and Performance tuning.

• Experience in Database Backup and Recovery process.

• *Experience with CDC, scanning of transaction logs in certain tables, inserting into certain tables.

• *Experience with (SSIS, SSAS, SSRS)

• Strong experience in database Backup, Restore and Recovery procedures and Isolation Levels.

• Thorough experience in Query Optimization, Tuning of Stored Procedures, and Performance Tuning

• Hands on experience and knowledge of high availability SQL Server solutions (DB Mirroring) and replication.

• Knowledge of active-active and active-passive clustering.

• Excellent skills in Integration and Extraction, Transformation and Loading (ETL) using different Transformation tools like DTS packages, BCP, and BULKINSERT, SSIS and also ETL third party tool Informatica 7.1 in SQL Server databases

• Planning, implementing and troubleshooting Replication

• Experience in implementing Log Shipping.

• Self-motivated, creative team player with effective communication and Leadership qualities.

• Team Management

• Business Development

• Sales/customer care training

• Sales/product development

Certifications: Certified People TV community producer, Certified Videographer, Videographer at Explore Studios shot 30 plus episodes

Technical Skills

• ________________________________________

MS Office

• PowerPoint

• Quick Books

Education

________________________________________

Portland St. University - Portland, OR

Bachelor of Arts, Psychology

Sac City Junior College - Sacramento, CA

Associate Degree, Psychology

RadiumSoft - Atlanta, GA 2010 - 2011

Advanced SQL Server DBA Certification Program, SQL 2008R2

Professional Experience

________________________________________

Global Tech POS – Atlanta, GA 2010 – 2012

SQL Server DBA

• Developed stored procedures, advanced queries, trigger, views, and indexes by using T- SQL

• Involved in Databases Migration

• Monitored and tuned databases to meet the performance and availability requirements.

• Created maintenance plans, scheduled jobs and DTS packages.

• Migrated the databases and managed the database location files and size.

• Created Clustered Indexes and Non-Clustered Indexes to increase the performance of database queries.

• Performed Defragmentation and rebuilding of indexes periodically on the production tables.

• Secured the SQL Server by creating user logins and Windows logins with appropriate roles, dropping and locking the logins, creation of groups, granting the privileges to users and Groups.

• Implemented database mirroring as a part of disaster recovery plan.

• Involved in resolving blocking and dead lock issues performance issues.

• Worked on clustering for Users on a High available environment.

• Troubleshooted and resolved SQL server connectivity issues.

• Transactional replication from the Production servers to the Reporting servers.

• Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps, integrity checks, and updating statistics.

• Installation and configuration of SQL Server 2008 r2 for both stand alone as well as clustered environments,

• Moved databases from Production to Test environment on request.

• Worked on daily reports which notifies about the database growth, failed jobs, failed backups and failed transactional log backups.

Rate Quest Investments - Newport Beach, CA 2003 - 2009

Investment Banker

• Managed multiple investors' portfolios placing millions of dollars into bank CDs ,working directly with banks, credit unions, and city municipalities

• Consistent high ranking sales performance

Contact this candidate