FASIL B. FETENE

Cell: 571-***-**** E-Mail: add8l9@r.postjobfree.com

Page 1 of 3

SQL Database Administrator

A highly motivated SQL Server Database Administrator with comprehensive knowledge of software development life cycle (SDLC) with over 10 years of experience in SQL database development and administration. I am seeking to work with a reputed company to achieve new levels of competence.

• Very good hands-on experience with T-SQL programming and good knowledge on RDBMS concepts.

• Proficient in creating objects such as stored procedures, tables, temp tables, views, triggers, user defined functions.

• You are proficient with SQL Server 2008 R2 / 2012 / 2014/ 2016 optimization, fine-tuning, and scalability techniques with knowledge of SSIS.

• Knowledge of High Availability (HA), Always On and Disaster Recovery (DR) options for SQL Server and Load Balancing solution to the production servers.

• Hands on experience in tuning T-SQL queries to improve database performance. E.g. examining query plans and creating appropriate clustered and non-indexes.

• Experienced in creating Jobs, SQL Mail Agent, Alerts and Scheduled ETL Packages.

• In-depth knowledge in SSIS data transformation and validation from heterogeneous data sources (OLE DB, Excel, Flat file, Oracle, DB2, MySQL, XML etc.) using ETL tools.

• Experienced in building OLAP cubes, fact and dimension tables with different architectures and data sources for business intelligence and populating/maintaining data marts in SSAS.

• Experience in using SQL server reporting Services (SSRS) and Power BI for creating various reports such as Parameterized, Cascading, Tabular, Matrix, Chart, Drill through and Drill down reports.

• Hands-on experience in ArcGIS Online, ArcGIS Server and ESRI geospatial technologies solutions.

• Maintain and update Power BI Reports and data process from various web sources (Dynamics, ODATA, SharePoint Online, Database, Web API/HTTPS).

• Certified in ServiceNow and knowledge of latest ServiceNow features.

• Certified in Security + and CISSP and ongoing knowledge in Security +, CISSP, Operating System, Cyber Threats and Defense, Network and Cybersecurity Strategies and Ethical Hacking Skills.

• Decision-making, problem-solving skills, critical thinking, and testing skills. PROFESSIONAL EXPERIENCE .

U.S. Department of Housing & Urban Development (Prosphere Contractor) May 2018 - Present Sr. Database Archtect

Provide support to multiple government projects/applications mainly CMISS, Hotline, ServiceNow.

• A member of software development team, as a backend database developer, working in a team collaborative environment such as GitHub and TFS.

• implemented the SQL Always-On architecture in SQL Server 2014 to provide High Availability and Load balancing solution to the production servers.

• Designed and created data warehouse and all data extraction, transformation and load (ETL) functions using SQL SERVER Integration Services (SSIS).

• Developed ETL packages to automate variety of manual data integration tasks or tweak some processes.

• Report Servers configuration and development of SSRS reports for multiple CMISS and Hotline request.

• SSRS Reports migration between dev, test and production environments.

• Working on Data bugs and fixes for existing applications; checking on SCOM Alerts and fixing them

• Performance tuning for SQL Servers, develop processes for optimizing database security.

• Automating DB backup and restore; creating SQL Jobs and scheduling them.

• Provide ServiceNow support in the absence of the Admin. Environment:

MS SQL Server 2012/2017/2018, SSIS, SSRS, Visual Studio 2012, Git GitHub, Git Bash, ESRI ArcGIS Online, CRM, SharePoint, Power BI, Excel, ETL, MDX, XML, Windows Server 2012/2016. Resume of FASIL

Page 3 of 3

Trexis/Alfa Insurance, Franklin, TN Sept 2017 – April 2018 SQL Server Developer/Administrator

Involved in migration of SQL Server from 2012 to 2016, created and modified many packages for many small other projects, highly engaged in optimizing Stored procedure.

• Working in Agile environment, created logical and physical design of database and database objects to fit new business requirement and implemented new design into SQL server.

• Created SSIS packages with OLE DB. ODBC, Flat file, Excel connections, SQL stored procedures implementing logic, used derived column transformation for converting data types.

• Created SSIS packages capable of looping through multiple servers using ADO Enumerator to generated SQL Server Agent Job reports.

• Looping through the files and archiving flat files after the data load to stage tables using SSIS.

• Highly proficient in packages to extract, transform and load data (ETL) using SSIS, designed packages which are utilized for tasks and transformations Data Conversion.

• Automating the SSIS package execution, creating dynamic packages, debugging, error handling in SSIS.

• Experience in transforming unstructured data from various data sources using SSIS like Conditional Split, Lookup, Merge Join and Sort.

• Sending Email notifications in case of failed recon execution and success execution of each recon.

• Optimized the performance of SSIS package and SQL stored Procedures for better package execution.

• Improved the performance of T-SQL queries and stored procedure by examining the query plan, creating computed columns for substrings and dropping and recreating appropriate indexes. Environment:

MS SQL Server 2016/2012, SQL Server Profiler and Query Analyzer, SSIS, SSRS, Visual Studio 2015, SharePoint, Power BI, Oracle, DB2, Excel, ETL, XML. Central Computing Inc. (CCi), MD Oct 2014 – Aug 2017 SQL Server/ BI Developer

The project involved in building a data warehouse to organize nationwide home health care services that are received from service providers. Prior to the development of the system the data existed in various RDBMS and post development the system is made as single stop for various needs.

• Analyzed the existing database structure, designed and normalized the databases, involved in installing and migrating databases.

• Responsible for running daily ETL processes and automating a variety of manual data integration tasks and designing SSIS packages to transfer the data from DB2, flat files and excels to the Staging Area.

• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Loop Containers, Fuzzy Lookups, and Derived Columns.

• Implemented Event Handlers and Error Handling in SSIS packages.

• Scheduled Packages using SQL Server Agent Jobs, monitoring nightly jobs.

• Installed, configured and maintained SQL Server Fail over cluster instances for 2 production environments.

• Experienced in Architecting and working with application team to implement multiple products across multiple agencies.

• Installed, Configured and maintained the log shipping architecture to provide backup server for production environment.

• Created the strategy and lead the Database team to maintain database environment for different agencies.

• Experienced in setting up Database Mirroring for Production databases.

• Experience with SQL Server disaster recovery procedures and created the guidelines for them.

• Experience in setting up the security for Production and development environments.

• Experience in maintaining critical production SQL servers and troubleshoot database Problems.

• Experienced in working very highly secure environments which related to US economy policies for Resume of FASIL

Page 3 of 3

multiple agencies.

• Experienced with improving SQL Server performance using performance monitor, index tuning wizards, profiler and execution plans.

• Created the maintenance plans for optimization and integrity checks for all available SQL Servers. Environment:

MS SQL Server 2012/2014, SSAS, SSIS, SSRS, Visual Studio 2012, ArcGIS server, JavaScript, Java, ASP.NET and HTML, SharePoint, Power BI, Erwin, Oracle, DB2, Excel, ETL, MDX, XML. TU Clausthal, Clausthal, Germany Apr 2010 – Sept 2014 Sr. SQL Server Administrator Claustral University of Technology, Germany

• Experienced in installing and configuring SQL Server 2012, SQL Server 2008 R2, SQL Server 2008 and SQL Server 2005 servers on Windows 2008 servers, applied service packs and security fix.

• Involved in upgrading SQL Server 2008 to SQL Server 2012. Tested the application after the successful upgrade.

• Installed, configured and maintained SQL Server Fail over cluster instances for 4 prod environments.

• Installed, Configured and maintained the log shipping architecture to provide backup server for production environment.

• Configured and maintained transaction and snapshot replication between the production servers for two different environments.

• Experience in setting up the security for Production and development environments.

• Experienced in creating backup strategy for prod, dev environment and implemented them.

• Experienced in Database Mirroring for Production databases.

• Experienced in SQL Server DTS, SSIS, SSAS and SSRS business intelligence data tools.

• Experience with SQL Server disaster recovery procedures and created the guidelines for them.

• Experienced with improving SQL Server performance using performance monitor, index tuning wizards, profiler and execution plans.

• Created the maintenance plans for optimization and integrity checks for all available SQL Servers.

• Experience in maintaining critical production SQL servers and troubleshoot database Problems.

• Responsible for securing SQL Server environment, involved in creation and granting permissions on various Objects, created the guideline to secure SQL Servers.

• Experience in improving server performance using performance monitor tool.

• Involved in Validating FDA regulated systems

• Involved in scripting, security, space management, jobs scheduling and maintenance, etc.

• Created Work instructions document for SQL Server 2012,2008R2 server installation, upgrade and apply patches.

• Experienced in database sizing and capacity planning for new and existing projects. Environment:

SSIS 2008/2012, SQL Server 2008R2, T-SQL, Visual Basic Studio, C#, .Net, Vb6, XML, Microsoft Project, Microsoft Access, SSRS, Microsoft Excel.

EDUCATION .

• PhD in G. Information Systems

• MCSA: SQL 2016 Database Administration

• MSc in Cybersecurity (Ongoing)

Contact this candidate