SUMMARY:

• I am a Highly Certified 17 years+ experienced SQL Server Developer and Database Administrator with relevant knowledge developing and architecting large scale enterprise SQL SERVER Business Intelligence, Data warehouse and Operational set ups.
• Gifted with a client - centered and proactive management style, I complement my SQL Server skills with Enterprise Architecture, Project Management, Business analysis, and communication skills.
• Good hands on manager and leader. More importantly, I am a great technical manager and a leader with great mentoring and emotional intelligence.

PROFESSIONAL EXPERIENCE:

Confidential, Reston, Virginia

SENIOR SQL SERVER DBA and Data Architect

Responsibilities:

• Installed and configured a five nodes SQL Server 2016 Always On Availability infrastructure with load balancing, in-memory tables and many other new features in support for the Center of Medicaid and Medicare (CMS). This was configured in a Distributed AG.
• Worked with other stakeholder for capacity planning and scaling of the SQL Server environment.
• Implemented security features such Dynamic Data Masking, Always Encrypted and row-level encryption.
• Installed and configured a three node windows and SQL Server clusters.
• Install, configure, administer and secure SQL Server 2012, 2014, and databases.
• Lead DBA teams in Database performance analysis, diagnosis and tuning (SQL Query Optimization, Storage and Network performance, CPU and Memory tuning, IO Load balancing etc.).
• Migrated the existing databases database infrastructure from SQL Server 2012R2 to 2016.
• Participate in capacity planning, trend analysis, performance forecasting exercises and propose recommendations to meet the ongoing performance and scalability demands.
• Successfully resolving SQL Server problems in conformance with SLAs, which involves in-depth knowledge of SQL Server architecture, connectivity, replication, SSIS, backup/restore, database corruption, security, and contribute to continuous improvement.
• Successfully created horizontal and vertical partitioning schemes to improve the performance of filtered queries on very large tables.
• Extensive experience hardening SQL Server setup after installation using techniques such as reducing the surface area, install only components that will be immediately used, avoid the usage of the default TCP/IP ports and install SQL Server Reporting Services (SSRS) on a different server from the database engine.
• Used hardening techniques such as disabling the network protocols that aren’t required and configuring administrative accounts to have the least permission necessary to perform their job, d eleting the \BUILTIN\Administrators account and disabling the systems administrator (sa) account and while setting up schemas and object ownership to enhance security and monitory.
• Mastering of additional security techniques such as using SQL Server local group rather than the service account directly and granting Lock Pages in Memory permissions to prevent trimming of memory managed to these accounts and Perform Volume Maintenance Tasks permissions to enable instant file initialization.
• Extensive experience with PowerShell scripting
• Excellent Experience in fine tuning and monitoring tuning from SQL Server 2000/ /2012/2014/2016 using SQL Profiler, DMVs, DBCC, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
• Create efficient indexing strategy to keep SQL Server performing at its peak using primary keys, unique constraints, cluster indexes, and non-cluster indexes.
• Perform SQL Server version upgrades, migrations and deployment changes to production databases.
• Hand on experience with SQL Server 2005, 2008, 2012, 2014 and 2018Clustering setups
• Create and maintain technical documentation and implement database related policies.
• Experience setting up release packages.
• Worked with several third party designing, auditing and monitory tools such as Idera, Toad, Redgate, Erwin and Solarwinds.
• Implement best practices for SQL Server database design, security, and backups.
• Create and support SQL Server clustering, various types replication, log shipping or database mirroring for servers around the world in several domains.
• Experienced using tools such as Backup Exec for backups or FogLight for database monitoring and troubleshooting.
• Experience conceiving, developing and reverse engineering databases using tools such as Erwin and MS Visio.
• Experience with Microsoft Business Intelligence and data warehousing tools such as SSIS, SSAS and SSRS.
• Responsible for production backup and recovery strategy using RMAN.
• Managed Logins, Users, Roles and User permissions, and conducted backup and recovery
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Good knowledge of Big data analytical tools such as Hadoop, NoSQL and Tableau.
• Extensive project management experience with techniques such as Agile and Scrum.

Confidential, Gaithersburg, Maryland

SENIOR SQL SERVER DBA/DEVELOPER

Responsibilities:

• Established the needs of users and monitoring user access and security.
• Tuned SQL query performance by avoiding coding loops, correlated subqueries and using Select sparingly.
• Conceived, developed and implemented an index strategy that improved the speed of data retrieval operations on a database table by providing rapid random lookups and efficient access of ordered records.
• Migration/upgrading of SQL Server \2012\2014 and applying Service Packs, extensive experience in migrating and new installations of SQL Server on Hyper-V & VMWARE and AWS Cloud environments.
• Extensive experience in high availability SQL Server Solutions that includes Always On, Mirroring and Clustering.
• Monitored workloads and figuring out how to maximize hardware resources to get the best SQL Server performance.
• Fine-tuned databases, stored procedures and ad-hoc queries.
• Performed needs/requirements analysis include talking to users, finding out their needs and requirements, and determining the best way to meet them.
• Monitored performance and managed parameters to provide fast responses to front-end users; mapping out the conceptual design for a planned database;
• Worked with stakeholders to consider both back-end organization of data and front-end accessibility for end-users;
• Refined the logical design so that it can be translated into a specific data model
• Refined the physical design to meet system storage requirements
• Installing and testing new SQL Server 2012 and 2014
• Used SSIS and SSRS to develop ETL packages and develop reports for the BI part of this project.
• Developed and Maintaining data standards, including adherence to the Data Protection Act;
• Wrote database documentation, including data standards, procedures and definitions for the data dictionary (metadata)
• Established database security to control access permissions and privileges.
• Developing, managed and tested back-up and recovery plans
• Configured RAIDs (0, 1, 5 and 10) to make sure that SQL Server was using the SAN effectively
• Ensured that storage and archiving procedures are functioning correctly.
• Did capacity planning working closely with IT project managers, database programmers and multimedia programmers.
• Installed and configured a 3-nodes disaster recovery and high availability with SQL Server 2012 Always On with manual and automatic failover respectively and asynchronous and synchronous data transfer.
• Communicated regularly with technical, applications and operational staff to ensure database integrity and security;
• Commissioned and installed new applications and customizing existing applications in order to make them fit for purpose.
• Conceived and implemented a SQL Server security and Policy Based Management in which Login password expiration were set, SQL server authentication was disabled, and successful or failed logins were captured and patterns recorded.
• To enhance security the NetBIOS protocol and the Server Message Block were disable by blocking the following ports UDP 137 and 139 and TCP 139 AND 445.
• To enhance security, the SQL Server Surface Area was reduced to minimum by installing only the necessary components. The authenticated was reinforced by using only windows authentication, given it the less privilege to perform its task, ensuring that it has a strong password, and that the password strength and expiration policies were enabled.
• To enhance security, database and database objects encryption was enable, likewise data in motion encryption.
• Good familiarity with the Federal Information Security Management Act (FISMA) where NIST information was categorized to protect Personal Identifying Information, organizational secrets and Intellectual Property. Each communication was labelled confidential, official, restricted or unrestricted. Controls were put in place to assess risks and document every bridge of security or protocol.
• Extensively involved in Database Design, Development and maintenance of database applications on SQL Server 2000/2005/2008/2012/2014 in OLTP/OLAP/BI environment.
• Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Worked independently as well as a proactive team member.
• Developing complex store procedures, efficient triggers, required functions, creating indexes and indexed views for performance.
• Designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Creating jobs, SQL Mail Agent, Alerts and schedule SSIS Packages.
• Extensively used SSIS with hands-on experience implementing Best Practices
• Prepared technical documentation
• Exposure to Large Databases (3 TB+) and heavy database loads
• Used SSAS and other OLAP technologies
• Dimensional Design Principles, such as Star and Snowflake Schema
• With strong T-SQL Query skills, wrote Performant Queries for Fast Data Loads
• Communicated data modeling and process flow concepts, while tailoring OLAP solutions to business requirements
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
• Creating Ad hoc reports and reports with complex formulas and to query the database for Business Intelligence.
• Developing Parameterized, Chart, Graph, Linked, Dashboard, Report on SSAS Cube and using SSRS to develop Drill-down, Drill-through And Cascading reports.
• Successfully developed conceptual, logical and physical data models; enforcing quality controls on all deliverables and artefacts.
• Successfully defined industry standard data models for Enterprise Data Warehouse, Operational data stores and Data Marts.

Confidential, Rockville, Maryland

SENIOR DATABASE ADMINISTRATOR (DBA)

Responsibilities:

• I lead and manage a team of databases administrators, database developers, functional persons, business analysts, testers, and system administrator. Teams range from sizes of 8 to 25 members depending on the project.
• Worked with senior management to translate their strategy to tactical and operational tasks to be performed by the team.
• Worked with both Dell and HP blades during the process of server consolidation.
• Made sure each members was performing their duty timely and that the necessary training was given to bring the team members up to date with the new technologies and systems.
• Excellent at transferring knowledge and experience through feedbacks and debriefing and good at motivating team members to perform their jobs effectively.
• Architect, Install, maintain and fine-tuning highly performing SQL Server database systems.
• Maintaining the database systems includes but not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Coordinating with the Systems Administration team, install and maintain School System approved application software and systems that integrate with School System's database systems.
• Used Oracle Business Intelligence and Report Designer to create reports
• Designing and configuration of clustering setup including active/passive nodes, SQL Server 2014/2012 Always On Availability Groups and Contained databases.
• Database and data warehouse architecting
• Configured a transactional and merge replications across domains involving firewalls, in which I created a distribution database, publications and subscriptions.
• Managed teams of DBA and developers and has also worked with offshore database developers resident in India.
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
• High mastering of table partitioning can make very large tables and indexes easier to manage, and improve the performance of appropriately filtered queries. Inserts and deletes become partition based instead of table base and the SQL Server Optimizer can better direct filtered queries.
• Extensive experience hardening SQL Server setup after installation using techniques such as reducing the surface area, install only components that will be immediately used, avoid the usage of the default TCP/IP ports and install SQL Server Reporting Services (SSRS) on a different server from the database engine.
• Used hardening techniques such as disabling the network protocols that aren’t required and configuring administrative accounts to have the least permission necessary to perform their job, d eleting the \BUILTIN\Administrators account, rename and disabling the systems administrator (sa) account and while setting up schemas and object ownership to enhance security and monitory.
• Design, document, and promote security "best practices", policies, standards and protocols.
• Migrating application code and objects from development/test environments to production.
• Working with development and systems teams to perform application and database tuning.
• In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development.
• Experience working with portals such as SharePoint 2013 farms, Cognos and Microstrategy Portals.
• Migrating Databases from SQL Server 2005 to SQL Server 2008 and /2014
• Setup and maintenance of appropriate database and application monitoring.
• Create efficient indexing strategy to keep SQL Server performing at its peak using primary keys, unique constraints, cluster indexes, and non-cluster indexes.
• Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
• Working with reporting tools such as Microstategy, Cognos, Microsoft reporting services and Crystal Reports to represent data in reports, graphs, dashboards and all sort of score cards.
• Have experience writing, editing, troubleshooting and debugging DLLs and DLMs commands in various version of SQL Server, starting from 6.5 to 2014.
• Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, SharePoint farms etc.
• Evaluating data modeling, database administration, and database backup and recovery tools and make recommendations.
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Review of physical and logical database design; Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.
• Create processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle.
• Experience creating cubes with SSAS
• Proficient using Red Gate tools
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2014/2012/2008/2005.
• Failover cluster testing and resolution on HP and Dell servers as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams.
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Implemented Policy management with policies such as Asymmetric Key Encryption, secured CmdExec Rights, disable Guest permissions, password strength and expiration, symmetric key encryption for user and system database
• Implemented encryption for sensitive data in which symmetric keys were used for data and asymmetric keys for the certificates. Password protection keys were used and all the keys were backed. More so, row level encryption was implemented for all sensitive or PII data.
• Implemented database ownership security by assigning alternative users as owners of databased and keeping the Cross-database ownership off.
• Checking Database Health by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning.
• Prepared Documentation for the Disaster Recovery plan
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Backups and Restores, fine-tuning, Optimization and troubleshooting and resolution of users’ access and performance problems.
• Experience with development languages such as HTML, ASP.NET, C#, T-SQL, .NET, VBScript and Microsoft JScript .
• Experience with visualization mostly with Hyper-V
• Migrating Databases from SQL Server 2005 to SQL Server 2008 and /2014
• Setup and maintenance of appropriate database and application monitoring using windows, SQL Server tools and third party tools such as FogLight.
• Setup, test and maintain business continuity/disaster recovery infrastructure for databases and applications.
• Setup and Configured a multi-nodes transactional replication between schools and the central office.

Confidential, Bethesda, Maryland

SENIOR SQL SERVER CONSULTANT

Responsibilities:

• Advised and mentor junior team members technically and morally.
• Installed and configured an enterprise wide SQL Server database architecture for an insurance company.
• Troubleshoot, solve, and prevent numerous SQL Server databases for various clients.
• Evaluated and provided solutions for various database problems such as slow running queries, poor designs, redundancy, corrupted databases.
• Developed schemes to prevent data corruption and database downtime for numerous Hitachi clients
• Disaster prevention and recovery
• Develop internal Enterprise wide reporting architecture using Business Objects 2000
• Create and develop revenue stream for Hitachi using Business Objects 2000.
• Demonstrate Hitachi’s wireless Business Intelligence knowledge at various Data Warehouse Conferences.
• Accompany Hitachi’s sales executive on various opportunity to serve as the Data Warehouse/Database and Business Intelligence technical liaison.
• Performed system optimization and performance tuning for numerous company.
• Developed backup and recovery strategy plan for many clients’ infrastructure
• Designed new availability architectural plan for new web site using SQL Server 2000 Enterprise and Windows 2000 Clustering technology.
• Developed Transact SQL coding standards for stored procedures, triggers and dynamic SQL.
• Created the conversion process to convert data from one single database to multiple databases on multiple servers.
• Developed procedures for OLAP Services Analysis Reporting System. Analyzed and created OLAP Cubes from Storefront and Web-Trends for Marketing group to analyze trends in buying habits with Analysis Server for SQL Server 2000 and Business Objects 5.1 and Web Intelligence 2.6