SUMMARY:

• 6 years of experience in SQL server DBA, SQL server Developer, SSRS, SSIS and SSAS. Experienced with multiple versions of SQL server (2008r2 - 2016) and working with development team.
• Creating Database Backup and Point-In-Time Recovery solutions and tuning SQL Server.
• Expert SQL writing and query optimization skills.
• Agile software development life cycle.
• Experience in designing, developing and maintenance of databases in MS Access.
• Configured and maintained SQL Server High Availability solution such as always-on, Replication and Log Shipping.
• Experience in SQL Server installation, Migration and configuration.
• Working knowledge in creating, managing and deploying reports using MS SQL Server Reporting Services (SSRS).
• Assigning SQL Server roles and granting permissions to users
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA)

TECHNICAL SKILLS:

Languages: T-SQL, PowerShell

Database Tools : SSIS, SSRS, T-SQL, SSDT, SQL Profiler, SQL Agents, SQL Alerts, SQL Jobs.

Databases: SQL Server 2016/ 2014/2012/2008 R2, MS-Access

Operating Systems : Windows Server 2012, 2008 R2

Application Tools: TFS, Visual Studio 2017/12/10, VSS

ETL Tools : SQL Server Integration Services (SSIS)

Modeling: MS Visio, erwin

Reporting Tools : SQL Server Reporting Server (SSRS), Crystal reports

Monitoring tools: SQL Profiler, Performance monitoring and activity monitor

Third party tools: TOAD for SQL, Redgate, SQL compare, SysAid

PROFESSIONAL EXPERIENCE:

Confidential, PA

SQL server DBA\ Developer

Responsibilities:

• Create Entity Relationship (ER) Diagrams.
• Installed and configured Always-ON for High availability and (DR) disaster recovery solutions.
• Created databases, Logins, Roles and granted appropriate permissions.
• Developed Stored Procedures, functions and database triggers and maintained integrity and implement complex business logic.
• Take regular database backup/restore planning
• Create complex joins to retrieve data from multiple tables for business analysis.
• Create database objects such as tables, views, stored procedures, Triggers etc.
• Responsible for database Maintenance tasks such as index fragmentation and DBCC operations
• Schedule SQL Jobs and alerts.
• Monitoring performance and optimizing queries for maximum efficiency.
• Plan databases growth and changes as a part of yearly capacity planning.
• Installed, configured, administered SQL Server 2014/2012/2008 R2 production and development environments.
• Check all databases to make sure, all databases are up and not marked as suspend.
• Resolving of potential blocking, deadlocking and write code to avoid those situations.
• Responsible for database Maintenance tasks such as index fragmentation, DBCC operations, monitoring performance and optimizing queries for maximum efficiency. participate in discussions involving the application creation and understand the requirements and provide the back-end functionality for the applications.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Technical Environment: SQL Server 2008R2/12/14, SQL Profiler, T-SQL, SSIS, SSRS, MS-Excel, DTS, SSMS, Crystal reports.

Confidential

Addis Ababa Ethiopia junior SQL SERVER DBA

Responsibilities:

• Check the success of regular database transactional and differential backups and server agent jobs for error.
• Installed, configured, administered SQL Server 2014/2012/2008 R2 production and development environments.
• Implement and maintain database security, conducts internal security audits to ensure no breaches.
• Take regular database backup/restore planning
• Schedule SQL Jobs | SQL server across multiple servers
• Monitoring & Managing the Table spaces and data files growth. Analysing Tables & Schemas, collecting system statistics and rebuilding indexes.
• Installed, maintained & monitored production SQL servers and making sure they are up-to-date with latest rollup hotfix and service packs.
• Installed and configured Always-ON for High availability and (DR) disaster recovery solutions.
• Migrated multiple databases in different SQL versions 2014\2012\2008R2 in both In-place and Side-by-Side migration methods.
• Moved several existing production databases, reports, linked server, logins and other computer objects to new versions of SQL server.
• Monitored database system details within the database, including stored procedures and execution time and implement efficiency improvements. worked on performance tuning, optimization of stored procedures and queries.
• Responsible for database Maintenance tasks such as index fragmentation, DBCC operations, monitoring performance and optimizing queries for maximum efficiency.
• Deployed database structures, such as tables, indexes and stored procedures from test to the production environment.
• Automated database refresh from production to test using custom scripts
• Set up linked servers between SQL servers.
• Created databases, Logins, Roles and granted appropriate permissions.
• Worked with Offshore team on pending issues and coordinating migration project activities to meet the project deadlines.
• Developed and deployed SSIS packages and SSRS Reports

Technical Environment: SQL Server 2008R2/12/14, SQL Profiler, T-SQL, SSIS, SSRS, SSAS, MS-Excel, DTS, SSMS, SysAid, Windows 2008/2012.