1. Explain why your background and experience would be a good fit for this job.
2. Tell us what has been your best work achievement to this point in your career. What made this achievement important?
3. Describe a difficult task you were faced with and how you addressed it.
4. Tell me about a situation in which you needed to make an important decision quickly, but were faced with conflicting information from multiple sources. Please describe the situation, your actions, and the outcome of your final decision.
5. Please describe a specific time you joined a team and worked with them to accomplish a common goal. Describe the situation, your actions, and the outcome.
6. Please describe a time you were asked to perform skills or meet requirements that were outside of your comfort zone. Describe the situation, the steps you took, and the outcome.
7. Why Should We Hire You?
Moses Odjodu
CAREER PROFILE/SKILLS:
Professional Summary
· A Database Professional with over 6 years’ experience managing mission critical databases on Prem and in the Cloud (Azure)
· I have extensive knowledge of Performance Tuning, Maintenance, High Availability and Disaster Recovery (HADR).
· Hands on experience in setting up and troubleshooting Always-On, Clustering, Database Mi
oring, Log Shipping, including Replication models (Snapshot, Transactional/Merge)
· Experience in Database Backup and Restore/Recovery, Query Optimization, Security, SQL Server Installation, Configuration of Stand-alone and Clustered environments
· Experienced in Migration/Upgrade, applying service packs and routine DBA operations like database health check, index optimization, updating statistics, client/server connectivity and capacity planning.
· Responsible for securing SQL Server, User Management, assigning permissions and roles
· Experienced in database security through configuring transparent database encryption (TDE) and dynamic data masking
· Experienced working with Service Now, SQL Sentry.
· Experienced in Active Directory (AD) objects and user permissions.
· Set up encryption Transparent Data Encryption (TDE), Always Encrypted, and Masking.
· Performance Tuning & understanding Monitoring Tools
· Worked with Service now Ticketing
EMPLOYMENT:
SCO Family of Services XXXXXXXXXXBrooklyn, NY XXXXXXXXXXJuly 2018 – Present
SQL Server Database Administrato
SCO Family of Services is a leading health provider with a very large database consisting of customer(s) and employees full information. The primary objective here is to maintain customer(s) and employees records, and make various databases accessible to users.
· MS SQL Server design, Development and administration using SQL Server 2005 – 2019 database environments.
· Monitoring SQL health check and identifying issues and fixing them.
· Used SQL Indexes for improving query performance, lower storage and maintenance cost
· Used Optimization tools such as SQL Profiler, Dynamic Management Views (DMVs) and Windows Performance Monitor for monitoring and tuning SQL Server performance.
· Implemented Installation, Configuration and Upgrading of SQL Server.
· Good experience in User Management and maintaining of databases.
· Automation of administrative tasks like creating jobs and schedules, alerts using SQL Server Agent monitoring and troubleshooting jobs, event notifications using Database Mail.
· Maintained server security by assigning logins, server and database roles and server permissions.
· Implemented disaster prevention and recovery strategies and supported High Availability features like Clustering, Always On, Log Shipping, Database Mi
oring and Replication.
· Maintained database response times in 24X7 production environment and proactively generated reports
· Planned and Implemented database backup
estore and disaster recovery
· Implemented Log Shipping from Primary to Standby servers
· Created and maintained SQL objects like Tables, Views, Stored Procedure, Constraints and User defined functions
· Used tools like Fog Light, Red Gate Sentry One, Solar winds Dpa for monitoring my environment
· Responsible for installing and maintaining SSIS, SSRS, and Power BI
Independent Living Association, Inc XXXXXXXXXXBrooklyn, NY XXXXXXXXXXAugust 2015 – Fe
uary 2018
SQL Server Database Administrator
· Implemented Always-On Availability Groups (AAG) and HA/DR Setup and Configuration
· Performed Regular Backup and Maintenance Jobs across the 150 Database Managed
· Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
· Installed and administered 3-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.
· Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
· Rebuilding / monitoring the indexes at regular intervals for better performance.
· Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
· Involved in troubleshooting and fine-tuning of databases for its performance and concu
ency.
· 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.
EDUCATION: XXXXXXXXXXB.S. 06/06: St. Joseph College
Brooklyn, NY
A.S.S. in Medical Office Technology: 06/04: TCI
Technical Career Institute – New York, NY
Certification
MCSE: Data Management and Analytics Microsoft Certified: Azure Administrato
Associate Exam 764: Administering a Microsoft SQL Database Infrastructure Expert
Exam 765: Provisioning SQL Database
Microsoft Certified: MCP
Reference:
Available upon request.