SQL Server DBA and BI Integration Specialist

Location:

Posted:

November 06, 2026

Resume:

PROFESSIONAL SUMMARY

Over ** years of experience in SQL Database Administration/development, BI solutions with Microsoft® SQL Server™ Integration Service (SSIS) and Reporting Service.

Have extensive work experience in Installation, Configuration and Maintenance of MS SQL Server 2014/2012/2008R2, 2008, 2005, and 2000 on a standalone and Clustered Servers [Active/Passive and Active/Active cluster design]

Setting up linked servers with the right privilege to let users run queries between SQL server and other data sources using ODBC, OLE DB drivers upon approval.

Extensive experience of creating,scheduling, monitoring and troubleshooting database maintenance jobs and application jobs on a production environment.

Experience with creating alerts, schema management, database reorganization, data loading, database maintenance and optimization

Strong relational database and ETL capabilities using SQL Server 2005/2008/2012 Business Intelligence Studio and SQL Server Management Studio.

Migration of SQL Server to Azure SQL Database

Experience in analyzing and designing of the software development life cycle

Experience in Database Backup, Recovery and Disaster Recovery procedures.

Experience in MS SQL Clustering, Replication and Log Shipping.

Experience in Performance Tuning and Database Consistency Checks using DBCC commands.

Provided system analysis, design, development and deployment of BI applications.

Experience in Debugging Stored Procedures and Triggers, Troubleshooting database issues.

Designed and maintained project databases using SQL; ensured accuracy of information and automated numerous functions.

Created and implemented database design solutions in collaboration with programming team. Analyzed and optimized MS SQL Server production databases.

Experienced in managing servers and staff in high-availability environments across multiple data centers.

Experience 24X7 on all Producion Support.

The ability to conceptualize, document, and communicate solutions to meet business objectives.

Excellent analytical, Interpersonal and Communication skills, fast learner, hardworking and versatile team player.

PROFESSIONAL EXPERIENCE

COINSTAR April 2020- Present

Bellevue, WA

SENIOR SQL DBA

Responsibities

Installation and Migration of SQL Server from 2008/2012 to latest versions

Setting up Replicaiton and works on disaster recovery techinques.

Troubleshooting database related issues and work on Performance Tunning

Setting up, maintaining and monitoring SQL Availability Group ( ALWAYS ON)

Responsible for configuration of advance features of SQL Server.

Setting up and using third party tools like NewRelic and DataDog for SQL and Windows monitoring.

Azure SQL Server Configuration and Management

Migration of SQL Server to Azure SQL.

Review Codes with Developers and undergo Deployment in Production Environment

Perform DBA tasks including backups, setting up access policy, data migrations, ETL operations, troubleshooting, data partitioning, replication and Query Optimization.

Highly Participated in physical and logical Design of database architecture.

Implement and maintain Database Security.

Technical Environment: Windows 2016 Advanced Server, SQL Server 2016,SQL 2014 and SQL 2012 Enterprise Manager, Management Studio,NEWRELIC,DataDog SQL Profiler, SQL Query Analyzer, ETL: COSMOS, MASS DTS MS SQL Server DTS, SSIS, DTS Designer Tools,Diagonstic Manager.

BOEING through PDS Tech JULY 2019- JUL 2020

Bellevue, WA

SENIOR SQL DBA

Responsibities

Responsible for performance Tunning and Always on Technologies.

Focuses on prioritizing in alignment with the SLAs, as well as direct connection with the production database activities.

•Designing and Monitoring Bulk Copy Process from Teradata to SQL Server.

•Regular database capacity planning related to database growth and system utilization, trend analysis, predictive future database resource requirements, and the structured organized reporting of the same.

•Works well in a cross functional team of tech leads, developers, architects and data modelers.

•Hands on proving-this-will-work-faster' attitude with ability to communicate to developers via working code samples.

•Powershell writing for Automation.

Proactive and reactive performance analysis, monitoring, troubleshooting and resolution of database issues.

Works on Jira Ticketing system to monitor Issues and deployments.

Work on high availability techniques.

Technical Environment: Teradata, Windows 2016 Advanced Server, SQL Server 2016,SQL 2014 and SQL 2012 Enterprise Manager, Management Studio,Gethub, SQL Profiler, SQL Query Analyzer, ETL: COSMOS, MASS DTS MS SQL Server DTS, SSIS, DTS Designer Tools

VISA through ADITI STAFFING APRIl 2017- APRIL 2019

Bellevue, WA

SENIOR SQL DBA

Responsibities

Responsible for providing DBA support for Dev and Production environments including maintenance, monitoring, automation, assessment and implementation of new technologies.

Focuses on prioritizing in alignment with the SLAs, as well as direct connection with the production DBAs activities.

•Design, implement and support a disaster recovery solution that leverages the ability to failover.

•Work closely with developers to ensure that database code meets defined company standards, provide performance analysis and help developers improve the performance of their code by tuning the query or modifying the indexes.

•On-call troubleshooting for database outages and emergency changes.

Proactive and reactive performance analysis, monitoring, troubleshooting and resolution of database issues.

Supports Golden Gate Replication for different databases.

Work on high availability techniques.

SQL Azure management and maintenance.

Technical Environment: Windows 2012R2 Advanced Server, SQL Server 2012,SQL 2014,SQL 2016 Enterprise Manager, Management Studio,Golden Gate, SQL Profiler, SQL Query Analyzer, ETL: COSMOS, MASS DTS MS SQL Server DTS, SSIS, DTS Designer Tools

Microsoft Via 110 Consulting Inc. Feb 2016- JAN 2017

Bellevue,WA

Senior SQL DBA/Operation Developer

Responsbilities

•SQL Database Administartion/operation/Management and Data Analysis.

•Working on TFS Source Code Managament.

•Setting up VMS and VM management – Deployed SSAS Cubes in different regional servers.

•Design, implement and support a disaster recovery solution that leverages the ability to failover.

•Proactively monitor server, database and ETL process health to ensure availability and performance.

•Work on Performance Tunning and Maintenance.

•Used Solar Wind for Database Monitoring purpose.

•Monitoring tabular and multidimensional solutions SSAS.

•Job Monitoring and scheduling accordingly.

•Ensure the refresh of different data sources and work on close cube process monthly.

•Worked on SSAS Cube refresh and SQL Server Agent Management.

•Participated in the ETL Code review.

•Monitoring and participating to move databases to SQL Server Azure cloud Environment.

•Build and enforce database change management, security standards and best practices across various database environments

•and ensure processes are adhered to and documented.

•Support production and non-production deployments of database schema changes, code deployments, and stored procedures.

•Provide support for development teams, collect database requirements and work collaboratively in order to provide solutions recommendations for new schema, infrastructure or architecture

Technical Environment: Windows 2012R2 Advanced Server, SQL Server 2012,SQL 2014, SQL 2016 Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL: COSMOS, MASS DTS MS SQL Server DTS, SSIS, DTS Designer Tools, Solar Wind.

Microsoft Via Launch Consulting Sep 2015- Feb 2016

Redmond, WA

Senior SQL DBA

Responsbilities

•SQL Database Administartion and Ensure high availability via monitoring Microsoft SQL Server Instance and database health and ensuring recoverability of data.

•Incident management, Break/Fix tasks, Restoring service to systems within SLA, communicating to customers if SLA is at risk.

•Problem management: Determining root cause of incidents and escalating bugs.

Performance troubleshooting and tuning (SQL Server, web services, etc.)

•Security administration:Granting access to the Analyst Workstation GUI and Granting access to databases

•Change/Release management:Attending bug triage for the various products and Providing input on new products, major versions, reviewing code, specs, etc.

•Automating OPS tasks and Powershell Scripting.

•Availability/Capacity Management:

•Monitoring the SCOM Queue to investigate and resolve alerts (related to server availability, performance, capacity, job exceptions, etc.)

•Maintaining backups (including tape library?)

•OS Patch upgrades, Service pack upgrades, etc.

•Supporting Big data ( COSMOS) and working on issues.

•Implementing Point-In-Time Recovery solutions.Worked in Windows Clustering, Always on and Replication.

Technical Environment: Windows 2012R2 Advanced Server, SQL Server,2008, 2012,SQL 2014 Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL: COSMOS, MASS DTS MS SQL Server DTS, SSIS, DTS Designer Tools

Microsoft Via Tech Mahindra May 2014- Sep 2015

Redmond, WA

Senior SQL DBA

Responsibilties

Administer, enhance and maintain client Microsoft SQL Servers. Ensure high availability via monitoring Microsoft SQL Server Instance and database health and ensuring recoverability of data.

Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.Worked in Windows Clustering and Replication.

Powershell scripting for Automating SQL Server.

Worked on Server maintenance, Scheduling server patching and Monitoring server health.

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

Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.

Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor(DTA).

Migration of Oracle Databases to SQL .

Worked with Development team in desgnign databases and resolving the designing issues that affects data performance.

Worked in the migration process of SQL dabatases to SQL AZURE Environment

Supporting different applications for treasury like Karnak, DTC, BAAT etc.

Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE).

Technical Environment: Windows 2008R2 Advanced Server, SQL Server,2005, 2008,SQL 2012 Enterprise Manager, Management Studio, SQL Profiler, Karnak,BAAT, SQL Query Analyzer, ETL, MS SQL Server DTS, SSIS, Oracle,DTS Designer Tools

Wizards of the coast/Cognizant 11/2013 to April/2014

Renton, WA

Senior SQL DBA

Responsiblities

Administer, enhance and maintain client Microsoft SQL Servers. Ensure high availability via monitoring Microsoft SQL Server Instance and database health and ensuring recoverability of data.

Supports online gaming, web publications, and physical product development and sales.

Supports and maintains Microsoft SQL Cluster servers for both active/passive and active/active clusters. Build a two node failover cluster using SQL Server 2008 R2.

Troubleshooting performance issues, deadlocks and long running queries using performance Monitor, Profiler and Activity Monitor

Code optimizations or suggested indexes need to be given to the development team for review and the QA team for testing.

Rebuilding the indexes at regular intervals for better performance

Uses Nagios, Splunk and SQL diagnostic Manager for event notification and centralizing management.

Migration of SQL 2008R2 to SQL 2012

Works on centerlaizing SQL Error alerts and monitoring the logs for crtitcal errors.

Create, schedule and maintain Jobs for routine tasks such as routine database refreshes, routine backup files requests as per the need of the business.

Prod/Staging/Test environment deployments

SQL server and Windows server administration.

Worked on maintaing Crystal Report.

SpotLight SQL server performance monitoring.

Use of Golden Gate Extract For Replication Purpose.

Configure and support high Availability Features like logshipping and Replication.

Use of Alwayson feature of SQL 2012

On call support 24x7 on rotation.

Technical Environment: Windows 2008R2 Advanced Server, SQL Server,2005, 2008,SQL 2012 Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL: SPLUNK,Spotlight, Golden Gate, NAGIOS, MS SQL Server DTS, SSIS, DTS Designer Tools

BROOKS Sports 05/2013 –10/2013

Seattle, WA

SQL DBA/Data Analyst.

Responsibilities:

Works to ensure that the associated software and hardware resources allocated to the databases deliver high resiliency and performance.

Proactively monitors the database systems to ensure secure services with minimum downtime.

Uses extract, transform and load (ETL) technologies to import data from transaction systems and other sources in to the operational data store for reporting.

Supports the design, development and management of all core business intelligence and reporting systems.

Troubleshoots and resolves problems related to user-based SQL development.

Improves and maintains the databases to include rollout and upgrades.

Implements and releases database changes according to agreed timescales and costs.

Works with the company user community to ensure accurate, current information is available to the users.

Provides technical support to users including troubleshooting hardware/software and integration problems.

Data extraction from Oracle and Managing the Oracle Database Environment.

Worked with Business to gather a server design specification for Implementation..

Provides advanced troubleshooting for applications and systems, determining cause and effect.

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

Mentor fellow IT colleagues.

Technical Environment: Windows 2008 Advanced Server, SQL Server,2005, 2008,SQL 2012 Enterprise Manager, Management Studio, SQL Profiler, ORACLE, SQL Query Analyzer, ETL: MS SQL Server DTS, SSIS, DTS Designer Tools

EXPEDIA, Inc. 06/2012- 12/2012

Bellevue, WA

Reporting Analyst/DBA

Responsibilities:

Installing and Configuring Reporting Services on Clustered Environment for High Availability

Assist in design and implement enterprise reporting and business intelligence solutions.

Assist developers and engineers to analyze database performance and identify problems in areas such as: execution plans, index coverage, and SQL server statistics

Demonstrates their knowledge of the business processes in their area of responsibility and can work with the Business to define requirements that will drive efficiencies in the business taking into account the entire picture as well as the details

Support building the enterprise data warehouse and extract data for analysis.

Managing and Admnistering SSIS and SSRS. Trouble shooting issues related to their failure.

Documentation and Analysis of data on Hadoop and DB2.

Extraction of Data from Hadoop and Creating databases and objects in SQL.

Develop ETL using SQL Server Integration Services (SSIS) and Report development using SSRS. OLAP design and build.

Configure Reporting Manager for subscription, email notification, drill down reports, data sources and users security

Management of own task list and appropriate prioritization within overall team, department and company requirements.

Maintain documentation for changes/enhancements to reports.

Provide regular reporting to management on progress and ensure that critical items are escalated as appropriate.

Trouble shooting database issues and worked on performance tuning.

Worked in Unix Environemt.

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

Technical Environment: Windows 2008 Advanced Server, SQL Server,2005, 2008 R2,2012 Enterprise Manager, Management Studio, SQL Profiler, Unix,SQL Query Analyzer, ETL: MS SQL Server DTS, SSIS, DTS Designer Tools, Hadoop, DB2

Microsoft (MSFT Business Online Services – Dedicated) Via SOGETI.

Redmond, WA

SQL DBA/BI ADMIN 09/2010 to 05/2012

Responsibilities:

SQL Server 2005/2008 development and Administration on Multiple Server Environment.

SQL Server Performance Tuning, SQL maintenance, networking and deployment management

Took a huge responsibility in Administration and development of SSIS and SSRS.

Extracted and Transferred data from different sources(e.g. Text File, Excel) to SQL Server DB and vice versa.

Troubleshooting and break/fix for incidents and supporting live site.

Used Splunk for Database Monitoring.

Created Proper Indexes to support performance of queries

Performed data compiling, Mining and Analysis required to evaluate the given data

Determine the methodologies and procedures for carrying out effective data analysis

Extract data from the relational database and prepared reports.

Monitored database size growth and resolved log space issues

Troubleshooting and break fix for incidents related to Databases/BI

Applied powershell scripting for improved maintainability.

Working on load capacity issues to structure jobs to run efficiently and effectively

Alert Analysis, Change/Add/Remove Alerts, Triggers, Scripts

Analysis of source systems and developing mappings to extract data into a data warehouse environment.

Worked on IIS Administration and Use of CRM technology.

Migration of SQL 2005 to SQL 2008

Used MS SCOM to monitor the health and performance of everything from servers to individual applications in Microsoft Windows environments.

Worked on log shipping, Mirroring,replication and other disaster recovery techniques.

Business Intelligence Administration and development.

Technical Environment: Windows 2008 Advanced Server, SQL Server,2005, 2008 Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL: MS SQL Server DTS, SSIS, and DTS Designer Tools

Microsoft (Microsoft Amalga Project)

Redmond, WA

Database Analyst 12/2009 to 07/2010

Responsibilities:

Worked closely with the Microsoft project team during the planning, configuration and testing of database connections to Microsoft Amalga Application.

Worked on Amalgam system configuration and give Support on Data base administration to healthcare enterprises, providers, researchers, and hospitals

Implemented and maintained a backup and disaster recovery plan.

Configured systems for clustering and backup/restore processes.

Worked on installation of SQL( multiple instances) on Virtual Machines ( Hyper-V)

Monitored and maintained appropriate disk storage requirements for the database

Set up Peer to Peer Replication, transactional and merge replication.

Supported application testing and insured proper database operation

Writing new Stored Procedures, T-SQL scripts, User Defined Functions (UDF) and Modify existing ones and tune them to perform well.

Maintained an ongoing configuration design and documentation for the databases

Performed routine tasks such as purging old files and checking disk space .

Resolved database issues and implemented performance tuning techniques.

Administered SQL Reporting Services and create/maintain SQL reports and Worked on SSIS (DTS)

Vertrue (Adaptive Marketing) Via Guru Alliance

Omaha, NE

SQL DBA 05/2008 to 08/2009

Responsibilities:

Supported the design of new Relational Database System for windows performance (SQL Server 2005)

Created several Stored Procedures, triggers, user defined functions (UDF), views to implement the business logic.

Fixed performance issues associated with stored procedures and queries.

Extracted data from the relational database and prepared reports.

Built database environments based on performance optimization

Installed SQL 2005/2008(active/active and Active/passive)

Supported web hosting environments: including adding/deleting web sites, web site performance monitoring and tuning, building/supporting web servers. Working on IIS.

Transactional Replication and Merge Replication and maintaining replication errors.

Applied Backup and restore mechanisms.( Also familiar with Light speed backup software)

Involved in maintaining of Stored Procedures, Functions and DTS Packages, enforced database triggers for auditing.

Worked on PCI SSC system.

Managed web servers and worked on Configuration of different features on websites using IIS.

Technical Environment: Windows 2003 Advanced Server/Server 2003, SQL Server 2000,2005, 2008 Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL: MS SQL Server DTS, SSIS, DTS Designer Tools, Windows Performance Monitor QUEST Tools.

Hewlett Packard via Vision System Group

Houston,TX

Position SQL DBA 03/2007 to 03/2008

Responsibilities:

Experience in migration and support of databases for Production, Integration and Development

environments ( Dedicated & Shared Databases)

Migration of databases from MS SQL server 2000 to MS SQL server 2005.

Migration of oracle 9i to 10g

Experience in Implementation of Production, Integration and Development environment,

Hardware requirements and support

Worked extensively on installation, upgrade and configuration of MS SQL Server 2005 and MS

SQL Server 2000 databases/ servers.

In migration process involved into PAR Review, Migration Review, preparing documentation

for reviewing process and migration, request for backup, migration, providing active support

after migrations.

Creation and maintenance of Users security permissions and Migrating the entire database

objects from one server to another server.

Extensive exposure to creation of databases, objects, stored procedures, triggers, security, DTS

(i.e. Import and Export), BCP, Transact-SQL, and SQL Server Agent and SQL Server profiler.

Implemented disaster recovery for SQL Server Production Database.

Technical Environment: Windows 2000 Advanced Server/Server 2003, SQL Server 2000-2005,

Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL: MS SQL Server DTS, SSIS, DTS Designer Tools, Windows Performance Monitor, ORACLE.

EDUCATION

Masters of information system, USA( University of Phoenix)

Bachelor of Natural Science, AAU (Ethiopia)

CERTIFICATION

Microsoft® Certified Professional (MCITP) SQL 2008

REFERENCE

Available upon request

Contact this candidate