OBJECTIVE:

I am a hard - working, innovative, productive, fast learner and result-oriented professional seeking employment in an outstanding company so as to grow professionally with Strong capacity to identify problems and challenges, as well as develop and implement technically advanced and effective solutions. Extensive technical skills, knowledge and more than 5 years of experience in MS SQL Server 2016/2014/2012/2008 R2/2005 in the areas of Installation, Configuration, Development, Maintenance, Performance Tuning, Backup and Restore, Disaster Recovery, Security, Data Transformation, Reporting Services and Business Intelligence.

SUMMARY:

• Over 5 years of experience as a SQL DBA in development and production environments.
• In-depth understanding of security and backup procedures to ensure database integrity.
• Background in developing backup and disaster recovery plans for nationwide offices.
• Superior communication, presentation, analytical and problem solving skill.
• Performance Tuning, Query optimization, and Database Consistency Checks using DBCC Utilities.
• Experience in executing Stored Procedures, T-SQL Queries and Triggers.
• Experience in implementing Log Shipping along with different types of Replication Models.

TECHNICAL SKILLS:

Database: MS SQL Server 2016/2014/2012/2008 R2/2008/2005, and MS Access.

SQL Server Tools: Enterprise Manager, Profiler, Query Analyzer, Export & Import, SQL Server Management Studio, SSRS, SQL Server Integration Services, SSAS.

Programming: T-SQL, Power Shell.

Reporting/Analysis Tool: SSRS, Hardware/Storage SAN, RAID

Data Modeling: SSDD (SQL Server Database Diagram).

Operating System: Windows Server 2012/2008/2003/2000 , MS-DOS, VMware, Windows NT4.0, UNIX/Linux (academic experience).

Database High Availability Technologies: Replication, Log Shipping, Mirroring, Clustering.

PROFESSIONAL EXPERIENCE:

Database Administrator

Confidential, Silver Spring, MD

Responsibilities:

• Strong knowledge and working experience in Database Backup & Restore.
• Experience with Point-in-Time Recovery.
• Working experience and strong knowledge in disaster recovery.
• Schedule jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification.
• Installed, Configured, and Managed SQL Server 2014, 2012, and 2008R2 in development, test, and production environment.
• Installed, Configured and Maintained Fail-Over Clustering.
• Configured Log Shipping and Maintained Replications (Transactional).
• Apply SP (Service Pack) on SQL Server 2014, 2012, 2008R2.
• Create Logins and Mapped the User to Roles by Assigning Permissions.
• Export & Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP.
• Daily monitoring of MS SQL Server activity, error logs, NT event logs, space usage and security.
• Configuring and auditing MS SQL Server security.
• Used DBCC to check database conditions and Rebuilding indexes as well.
• Detected and Resolved locks and Deadlocks using the Trace Flags and Native tools like Profiler and Activity Monitor.

Jr. Database Administrator

Confidential

Responsibilities:

• Installation, configuration, monitoring, upgrading, patching and tuning of MS SQL Server 2008R2/ 2008, and 2005.
• Migrated MS Access 2000/97 databases to SQL 2005 and 2008.
• Performed Performance Tuning of the database, Stored Procedures and SQL queries.
• Security Administration: creation of users, Roles and granting appropriate privileges.
• Involved in Day-to-day activities such as Agent Jobs, Backups and Recovery, Services, Index, Database growth, health, consistency check etc.
• Monitor and tune all aspects of SQL Server infrastructure like Disk, CPU, Memory, SQL Code etc., by using Profiler, Dynamic management views.
• Worked as team player in resolving issues, documentation etc.
• Background in developing backup and disaster recovery plans for nationwide offices.
• Monitoring jobs performance.
• Developing and testing a backup and disaster recovery Plan.

Loan Officer

Confidential

Responsibilities:

• Explain to customers the different types of loans and credit options that are available, as well as the terms of those services.
• Obtain and compile copies of loan applicants' credit histories, corporate financial statements, and other financial information.
• Appraise loans within specified limits, and refer loan applications outside those limits to management for approval.
• Meet with applicants to obtain information for loan applications and to answer questions about the process.
• Analyze applicants' financial status, credit, and property evaluations to determine feasibility of granting loans.
• Review and update credit and loan files.
• Review loan agreements to ensure that they are complete and accurate according to policy.
• Submit applications to credit analysts for verification and recommendation.
• Handle customer complaints and take appropriate action to resolve them.
• Work with clients to identify their financial goals and to find ways of reaching those goals.
• Negotiate payment arrangements with customers who have delinquent loans.