SUMMARY

• Database professionals perform installation, maintenance, and configuration task, also setup database system, making sure those systems operate efficiently, and regular storing.
• Five + years of database management experience that includes Database Administration, System Analysis and Design, Development & Support of MS SQL Server 2008, 2008R2, 2012, 2014 and 2016 environments.
• Experience in using dynamic management views (DMV) and dynamic management functions (DMF), TSQL scripts, Triggers, and Store Procedure for troubleshooting and performance tuning.
• Security Management - Access and security management, creating Logins with appropriate roles, creating users and groups and granting privileges according to company policy.
• Experience in coordinating and supporting server level hardware and software maintenance, windows patching and application migration/upgrade.
• Monitoring error logs, database space allocations, transaction log space allocations for performance and documentation of errors and resolutions for future references.
• Competent, experienced, and highly dependable professional, Proficient at producing and completing quality outputs, recognized for performing all duties and responsibilities in compliance with standard operating procedures. Known for demonstrating exceptional work ethic. Equipped with communication and interpersonal skills. Versatile and easily adapt to changing environments.
• Extensive experience in installation and configuration of MS SQL Server, applying service packs, hotfix and cumulative updates in Production and non-production environments.
• Extensive experience in performance tuning/analysis, troubleshooting and query optimization.

TECHNICAL SKILLS

• Database: SQL Server 2016/ 2014/2012/2008 R2/2008
• Operating Systems: Windows Server 2003/2008/2012
• SQL Server Tools: SSMS, SSCM
• Troubleshooting: server error log, Activity Monitor, Query Analyzer, Profiler
• ETL Tools: SSIS/DTS, Import/Export Wizard

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

DBA

Responsibilities:

• Installed and configured MS SQL Server 2012/2014 on standalone and clustered environments.
• Experienced in migrating contents from MS SQL server 2008 to MS SQL server 2016 and 2005 to 2012.
• Experienced in applying 2012 /2008 periodic service packs and hot fixes (cumulative updates).
• Managed MS SQL Server 2016/ 2014/2012/2008 databases.
• Auditing of databases for user's transaction, login and database action and fixing orphan users.
• Managed users and groups (roles) from Active directory or SQL, provide appropriate server roles, map them to specific databases and grant specific privileges over selected database securable objects to ensure security and integrity.
• Reviewed and optimized SQL queries, stored procedures, views and triggers from other developers to achieve maximum efficiency and scalability. Provided consultation for development teams regarding performance review and the correct usage of database objects and list the most resource-intensive queries on the server and suggest ways to improve performance on each.
• Responsible for creating and monitoring database maintenance plans and schedule jobs using SQL Agent/Maintenance plan; Schedule database integrity check, reorganize/rebuild indexes, update statistics, backup/restore and cleanup job history.
• Extensively used SQL native tools for performance monitoring /analysis and troubleshooting. Performance tuning by analyzing execution plans, creating and maintaining indexes (rebuild/reorganize), Statistics and Client/Server Connectivity.
• Analyzed and deployed scripts and packages in prod/test environments from different developers based on CR/change request process.
• Involved in capacity planning and allocation of resources for the databases by assisting application teams in creating databases depending upon the criticality of the databases following current and best practices in accordance with SLA of the company.
• Involved in database Consolidation project.
• Responsible for forecasting data growth of databases and providing reports on quarterly basis.
• Analyzed Locks, Blocks, Dead Locks, Resource Utilization, handling Isolation Level and Concurrency issues.
• Supported implementation of Always ON, Availability groups by creating availability databases using the high availability and DR strategies in clustered environment.
• Experienced with configuring database high availability techniques like Replication, clustering as well as implementing disaster recovery techniques like database mirroring and log shipping.
• Used free tools to diagnose server reliability and performance issues.
• Monitored SQL Server Error Log, Windows Event Logs, Profiler, Query Execution Plan, Index Tuning Advisor, Database Tuning Advisor, System Monitor, troubleshooting performance issues.
• Experienced in implementing, configuring and maintaining different types of Replication Models like Snapshot and Transactional.
• Implemented database refresh using SSIS packages and automated backup/restore jobs.

Confidential, Virginia Beach, VA

Responsibilities:

• Installed, Configured, and Managed SQL Server 2014/2012/2008 in production, development and test environment.
• Applied 2012/2008 /2005 periodic service packs and hot fixes (cumulative updates).
• Experience in migrating contents from MS SQL server 2005 to MS SQL server 2012.
• Experienced with Point-in-Time Recovery that meets company's RTO and RPO. Plan backup strategies based on the recovery models, size of data and l\0 activity.
• Design, implement and manage database maintenance and disaster recovery plans including full/differential/transactional backups and recovery procedures.
• Implemented pre/post strategies for upgrading and migration of user databases by scripting all SQL server replications, login/users, linked servers, scheduled job, database mail profiles and server level configurations.
• Analyzed Locks, Blocks, Dead Locks, Resource Utilization, handling Isolation Level and Concurrency issues.
• Managed database security, creating logins, groups, users, and server level and database level roles following company policies and procedures.
• Created Alerts and Notifications for system errors, insufficient resources, fatal database errors, hardware errors, security breach, etc.
• Strong knowledge and working experience in Database Backup and Disaster Recovery.
• Managed efficient backup system to minimize backup/restore time by applying Database Backup Compression, enabling Instant File Initialization and applying frequent full, differential and transaction log backups.
• Imported data from multiple sources such as Flat file, CSV file, Access, OLEDB data sources to SQL Server. Data migration to and from various sources using SSIS.
• Experienced in Extract, Transform and Load (ETL) data from heterogeneous data Sources; MS Access using MS SQL Integration Service (SSIS), DTS, BCP and Bulk insert. Exported data from SQL Server to multiple destination/format such as Flat file, CSV file, Access, OLE DB data sources.