Harris Anja

SQL Server Developer

ac8gbj@r.postjobfree.com Skype: Harris.Amele Cell: 940-***-****

PROFESSIONAL SUMMARY

Over 8 years of experience in the IT industry as SQL Developer/Admin.

Experience working in an Agile environment to deliver complex software product in various businesses. Lead team in software planning, and development.

Deep understanding of Data modeling, data warehouse, and data architecture.

Hands on experience in T-SQL queries optimization (performance tuning ) in large databases using various tools and technique.

Hands on experience in creating, designing databases and ensuring efficiency, stability, reliability and performance,

Experience in creating store procedures, functions, Views, triggers, complex joins, transactions, advance select/update statements in various environment.

Experience in creating complex report with parameters, drilldown, drill through and other functionality in BI reporting (SSRS)

Experience in ETL Developing tools, using various transformations to cleanup data from various sources to destination

Experience in creating packages in SSIS with various source file (excel, flat, XML etc.)

Well versed with database installation, configuration, maintenance, monitoring, backups and recoveries.

Expertise in trouble shooting, performance tuning, backup, restore procedures and disaster recovery with High availability strategies (Replication, log shipping and mirroring).

Implemented CDC (Change Data Capture) and Change Tracking in SQL Server for capturing changes for data warehouse environment.

Deep knowledge of migration (in place upgrade and parallel upgrade) of various SQL server

Authorized to work in United States for any employer

Work Experience,

Title: SQL Developer/DBA 09/2017 to Present

I-ping solutions, Client: Peoples mortgage

Create Database object like Stored Procedures, functions and database triggers and maintained referential integrity to enhance database performance and to support business application.

Write complex joins to support business application and to retrieve information from various table for BI analysis in large databases.

Monitor performance of large databases and tune slow running queries as necessary. Build and reorganized indexes. Used SQL profile, Tuning advisor, column store index, table partitioning and analyzed execution plans to escalate complex performance issues

Write advanced select statement to retrieve data from various tables for business analysis. Created and maintained database objects, created complex Stored Procedures, Tables, Views & SQL Join statements for various applications.

Developed database monitoring and tuning strategies. Tuned Complex SQL Queries. Used management to create backup maintenance plans to minimized data lost.

Designed and implemented security of Databases and objects (Creating User logins, application logins, roles, groups and granting Permissions on objects base on business policies). Resolve logins issues and password issues.

Provided on-call support for various projects. Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers. Automated and enhanced daily administrative tasks including space management, database backup and recovery

Checked Database integrity and consistency by using DBCC Commands and DMVS

Wrote and debugged Stored Procedures and (DDL /DML) Triggers, Functions per requirements

Extensively worked on trouble shooting and fine-tuning of databases for its performance

Designed and implement comprehensive Backup plan and disaster recovery strategy. Prepared Documentation for the Disaster Recovery plan in a production server and Dev server.

Design, configure, and monitor high availability strategies ( SQL replication, log shipping, and mirroring) to minimized data lost and to support business application .

Daily routine Developer/DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.

Rebuilding the indexes at regular intervals for better performance

Responsible Monitoring and troubleshooting Log Shipping issues and other issues in always on availability platform

Performed all basic Database activities like moving databases between servers, copy databases, detach etc.

Developed SSIS packages using various transformation to clean, and secure data consistency, and integrity with source and destination.

Deploy SSIS packages and create jobs in SQL Argent job to run packages automatically at scheduled time.

Debugged packages troubleshoot to resolve issues when packages fail. Write and document better methodologies of better package designing and deployment

Involve in a development team that perform migration of SQL server ( parallel upgrade SQL server 2008 to 2012). Resolve issues that arises during upgrade and document steps of resolution.

Environment: SQL Server 2012/2014, SSRS, MS EXCEL 2003, MS Access 2003, MS SQL Query Analyzer, SQL Profiler, SSIS, Windows 2003 Server, Microsoft Dynamics AX/365

Junior SQL Developer/Admin

Client :Texas Department of criminal Justices 02/2015 – 07/2017

Responsibilities:

Designed and implemented comprehensive Backup plan using SQL LiteSpeed.

Resolved and tweaked memory pressures caused during product release.

Worked with customers on Application rollouts and server migrations.

Troubleshoot performance problems and fine-tuning of databases.

Expertise in designing databases and capacity planning.

Rebuilding the indexes at regular intervals for better performance.

Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.

To provide 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.

Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.

Monitored and modified Performance using execution plans and Index tuning.

Rebuilding the indexes at regular intervals for better performance.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers

Designed and create databases, tables, views, store procedures and triggers. Performed joins of various types and on multiple tables. Perform Database and table scripting for quick creations of table with similar objects and structures.

Environment: SQL Server 2008 20012, SSRS, MS EXCEL 2003, MS Access 2003, MS SQL Query Analyzer, SQL Profiler, SSIS, Windows 2003 Server, Microsoft Dynamics AX/365

Title: Support SQL Database Developer.

Client: American airlines 4255 Amon Carter Boulevard Ft Worth, TX 04/2012 to 01/2015

Responsibilities:

SQL Database Administrator, Database Programming.

resolve highly complex, technical, and escalate support incidents. troubleshoot and diagnosis issues in SQL Server environment.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Rebuilding indexes at regular intervals for better performance in large datasets

Designed and implemented comprehensive Backup plan and disaster recovery strategies.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Monitored and modified Performance using execution plans and Index tuning.

Deploying new code base release to UAT and Production Environments.

Perform SQL Server service pack and Windows Service pack upgrades.

Working with customers on Application rollouts and server migrations.

Extensively worked on Enterprise Manager for managing the database.

Troubleshoot performance problems and fine-tuning of databases.

Converting DTS packages into SQL Server 2005 Integration Services.

Migrating SQL Server 2000 data bases into SQL Server 2005.

Environment: SQL Server 2005/2008, SSRS, MS EXCEL 2003, MS Access 2003, MS SQL Query Analyzer, SQL Profiler, SSIS, Windows 2003 Server

Technical Skills:

SQL Server Tools SSMS, Enterprise Manager, Profiler, Query Analyzer, Export & Import (DTS), SSIS, SSRS, SSAS

RDBMS MS SQL server 2005/2008/2012, MS Access

ETL DTS, SSIS

Programming Languages SQL, T-SQL, PL-SQL

Internet Technologies XML, HTML

Productivity Applications SQL Litespeed, SQL Sentry, Quest Spotlight, SQL Compare

Operating Systems Windows 2003/2008/2000/XP/7

Knowledge and understanding of SQL Server Integration Services (SSIS)

Education

Southern Methodist University Aug 2013-Dec 2015

Ms Computer Science

University of Yaounde1 Sep 2005- 2008

Bachelor’s in computers and information technology (2009)

Certified AWS Architect Associate – Edureka!

Certified Agile Scrum Practitioner – Qualistik Professionals, LLC- Completed

Certified MCSA - Colaberry

Professional Summary

Contact this candidate