SUMMARY

• 5 years of experience in analysis, design, development and administrator of various databases.
• Installation of SQL Server 2008 Enterprise Edition with Service Pack1 and configured and maintained MS SQL Server 2005 Enterprise Edition.
• Develop SQL database and design applications to interface with SQL database
• Migration from SQL 2005 to SQL 2008R2. During the Migration moved 200 instances to 14 instances and consolidated all the databases according to their categories, migrated all Logins and Jobs at the new servers along with the Orphan users checks.
• Created new logical and physical database design to fit new business requirements and implemented it to the SQL Server 2008.
• Using HTML system for tagging text files to achieve, font, color and happerlink effects on the web page.
• Implemented Database mirroring in SQL 2008/2005.Monitored growth of data and managed space allocation accordingly, Installed and configured Log Shipping for production servers.
• Consolidate and optimize available data warehouse infrastructure
• Created Database Maintenance Plans for Re - indexing, Database Integrity Checks, Shrink Database.
• Carry out monitoring, tuning, and database performance analysis
• Developed Stored Procedures, Functions, Tables, Views and other T-SQL code and SQL joins for applications.
• Created Backups for databases and automated the process.
• Performed Resource GovernorIn SQL 2008.
• Implemented and tuned Replication (Snapshot, Transactional, and Merge) for the use of reporting server.
• Ensured integrity of data maintained through security, documentation, and change management.
• Created and managed schema objects such as tables, views, clustered indexes, procedures, and triggers and maintained Referential Integrity of the databases.
• Created jobs and alerts for monthly and weekly maintenance.
• Creation and maintenance of Databases, creating roles and managing user permissions, resolving Blocks and deadlocks.
• Monitored SQL server and Application logs and analyzed the logs.
• Created operators and alerts in getting notifications and assigned permissions to the Users in appropriate Roles.
• Good Experience in BI ( Business Intelligence) Using SSIS (SQL Server Integration Services )
• Creating and maintaining data maintenance plans using MySQL/SQL.
• SQL/MySQL - report generation, statistics, data mining
• MySQL and SQL query optimization, bottle-neck analyzes, performance problem solving
• Excellent skills in analyzing client’s requirements, modeling the system, and ensuring the functionality, with client satisfaction as the primary focus. Capable of delivering optimized, effective and well-documented code.
• Designed and Created Tables, View, Triggers, Stored procedures, using MS SQL Server 2012 and 2008.
• Involved with SSIS for sending and reviewing data from heterogeneous sources like (Excel, CSV, flat file, Text Format Data).
• Consolidate and optimize available data warehouse infrastructure
• Involved in Scheduling and monitoring the ETL packages.
• Experience in using agile methodology (SCRUM).
• Created scripts to migrate existing content from MySql database using Entity Framework into site core items.
• Implemented of comprehensive backup and database replication solutions.
• Installed various versions of MySQL across multiple environments.
• Excellent computer skills with Microsoft applications, Ms excel, Ms word, Ms Access, Power point
• Ensure all data warehouse architecture codes are maintained in a version control system.

TECHNICAL SKILLS

Database: SQL, MYSQL, Oracle11gFrameworks.Net Framework 4.0/3.5/3.0

Languages: C#, C++, Visual studio

RDBS: MS SQL Server 2012/2008/2005 , MS Access

Markup Languages: CSS, HTML, and XML

Development Environments: SDLC, Agile Scrum, waterfall

Software Architecture: N-tire, Client server, File Server

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Database Developer

Responsibilities:

• Installation of SQL Server 2008 Enterprise Edition with Service Pack1 and configured and maintained MS SQL Server 2005 Enterprise Edition.
• Develop SQL database and design applications to interface with SQL database
• Migration from SQL 2005 to SQL 2008R2. During the Migration moved 200 instances to 14 instances and consolidated all the databases according to their categories, migrated all Logins and Jobs at the new servers along with the Orphan users checks.
• Created new logical and physical database design to fit new business requirements and implemented it to the SQL Server 2008.
• Designing and implement ETL procedures for intake of data from both internal and outside sources
• Using HTML system for tagging text files to achieve, font, color and hyperlink effects on the web page.
• Implemented Database mirroring in SQL 2008/2005.Monitored growth of data and managed space allocation accordingly, Installed and configured Log Shipping for production servers.
• Created Database Maintenance Plans for Re-indexing, Database Integrity Checks, Shrink Database.
• Developed Stored Procedures, Functions, Tables, Views and other T-SQL code and SQL joins for applications.
• Created Backups for databases and automated the process.
• Performed Resource GovernorIn SQL 2008.
• Implemented and tuned Replication (Snapshot, Transactional, and Merge) for the use of reporting server.
• Ensured integrity of data maintained through security, documentation, and change management.
• Created and managed schema objects such as tables, views, clustered indexes, procedures, and triggers and maintained Referential Integrity of the databases.
• Created jobs and alerts for monthly and weekly maintenance.
• Creation and maintenance of Databases, creating roles and managing user permissions, resolving Blocks and deadlocks.
• Monitored SQL server and Application logs and analyzed the logs.
• Created operators and alerts in getting notifications and assigned permissions to the Users in appropriate Roles.
• Good Experience in BI ( Business Intelligence) Using SSIS (SQL Server Integration Services )
• Good Experience in SSRS and ETL
• Creating and maintaining data maintenance plans using MySQL/SQL.
• SQL/MySQL - report generation, statistics, data mining
• MySQL and SQL query optimization, bottle-neck analyzes, performance problem solving
• Excellent skills in analyzing client’s requirements, modeling the system, and ensuring the functionality, with client satisfaction as the primary focus. Capable of delivering optimized, effective and well-documented code.
• Designed and Created Tables, View, Triggers, Stored procedures, using MS SQL Server 2012 and 2008.
• Involved with SSRS/SSIS for sending and reviewing data from heterogeneous sources like (Excel, CSV, flat file, Text Format Data).
• Involved in Scheduling and monitoring the ETL packages.
• Experience in using agile methodology (SCRUM).
• Created scripts to migrate existing content from MySql database using Entity Framework into site core items.
• Implemented of comprehensive backup and database replication solutions.
• Installed various versions of MySQL across multiple environments.
• Excellent computer skills with Microsoft applications, Ms excel, Ms word, Ms Access, Power point

Environment: MS SQL Server 20012/2008/2005

Confidential, Addis Ababa, ETH

SQL Server Developer

Responsibilities:

• Developed and maintained performance dashboards and reporting for the Operations team to support the strategic reporting needs of the business regarding how the clients require.
• Responsible for the daily action plans for the projects and assist with all implementation
• Leading data migration process for clients
• Installs, configuration, and troubleshoots desktop systems, workstations in production environment.
• Developed and maintained standards for reporting, administration and operations including the scheduling, running, distribution, monitoring, logging, management of errors, recovery from failures, and validation of outputs for the reporting for the back office levels.
• Administration and management of the entire development and production environment.
• Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization.
• Perform the design and extension of data marts and data models.
• Reported and Implemented best practices, standards and procedures in accordance with the company's business Intelligence.
• Experience Database replication setup and configuration
• Immense ability to articulate technical requirements
• Creating and maintaining data maintenance plans using MySQL/SQL.
• SQL/MySQL - report generation, statistics, data mining
• MySQL and SQL query optimization, bottle-neck analyzes, performance problem solving
• Implemented of comprehensive backup and database replication solutions.
• Installed various versions of MySQL across multiple environments.
• Excellent computer skills with Microsoft applications, Ms excel, Ms word, Ms Access, Power point
• Maintains password security, data integrity and file systems security desktop environment.
• Ability to work with in multiple technical/business team and provide end-user training
• Gathering of business requirements and creating architectural designs.

Environment: MS SQL Server 20012/2008/2005 , MS Access, Oracle11g, Linux