SUMMARY

• Experience in Database System Analysis, Design, Implementation and Administration of MS SQL Server2016, 2014, 2012, 2008R2, 2005.
• Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading, and Migrating from RDBMS like Oracle, MS Access, and Sybase to SQL Server 2016/2014/2012/2008 r2& R2/2005/2000 on Clustered and Standby Environments.
• Database High Availability Solution in Test and Production environment.
• Strong experience in Configuring, Managing and Administering Database AlwaysOn Availability Groups, Failover Clustering, Log Shipping & Replication as a D/R and H/ A solution.
• Excellent Experience in Designing, Configuring, Implementing and Administering SQL Server installing and configuring and upgrading of SQL Server failover cluster as a H/ A Solution in physical server and VM Environment
• Experienced in analyzing data integration, developing ETL process using SSIS and BIDS
• Hands - on experience with T-SQL in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
• Experience in Performance Monitoring and Tuning for Instance, Database, and SQL Query using execution plan, Database and Index Tuning Tools and Monitoring Server Activity, Error Log, space usage, and solving problem as needed
• Experience on SQL Server Reporting Services, using SQL/T-SQL Scripting for customized Report Generation and Management
• Experience in setting-up, and Managing Database Maintenance Automation like different types of Database Backups jobs, Index Management, Update Statistics History Cleanup etc.
• Experience in Managing Database Security and Audit and Applying SPs for SQL Servers & OSs.
• Configuring and setup Database Mail Server for database mail notification
• Experience in Database deployment in Production and refreshing in test environment
• Experience in administering AD (Active Directory)/Domain and monitoring user activities

PROFESSIONAL EXPERIENCE

Confidential - Washington, DC

Responsibilities:

• Responsible to run the scripts & packages deployment on Test and Production physical and VM server
• Configure and maintain database servers and processes, including monitoring of system health, index fragmentation, Monitoring agent jobs and performance to ensure high levels of performance, availability, and security.
• Provides AOAG, Cluster and data center Database administration, operational support, and problem resolution
• Backup, recover, Restore and refresh Test and Prod.
• Create the Database and Migration the database from difference version and edition use DACPAC
• Restore/Refresh database from Prod and Test
• Create the Maintenance plane
• Create web site Application, Bindings, create user account, configure and import/Export Application, deploy, Recycle use IIS server

Environment: SQL Server 2016/2014/2012/2008 R2, Windows Server 2016/2012R2, SSMS18.4

Confidential - Washington, DC

SQL Database Administrator

Responsibilities:

• Perform Server/Workstation Security and maintenance updates
• SQL Maintenance across multiple systems
• Creating New and Validating current and new backups of SQL Systems
• Supporting COOP functions of Windows systems with active SQL databases
• Maintain system configuration documentation
• Maintain system process and procedure documentation
• Maintain patch versions and Department of Defense (DoD) Security Technical Implementation Guides (STIG) levels on all network Servers, workstations, and laptops
• Provide technical support and implementation for workstations, servers, and virtual terminals
• Provide installation support for network systems applications
• Support as needed DoD Information assurance Risk Management Framework (DIARMF)
• Manage Active directory, DHCP, and DNS
• Reset user account passwords within Active Directory Users and Computers
• Unlock user accounts within Active Directory Users and Computers
• Create user accounts for PBMN within Active directory users and Computers
• Run AD Janitor- Weekly- Disable any accounts which have not been logged into within 30 days.
• Maintain inventory of all laptops, desktops, servers, monitors, etc.
• Provide Tier 1&2 support to the FSD user community. work with other team members to analyze and resolve problems and perform preventative maintenance.

Confidential - Washington, DC

SQL Database Administrator

Responsibilities:

• Installed, upgraded and migrated to windows 2012r2 and SQL Server 2017.
• Installed, configured and tested vendor software on both the backend and front end for the company for selecting vendors to company.
• Testing the connections performance and reliability of vendor software.
• System Administration tasks like creating of application user accounts, assigning responsibilities to the user accounts, enabling required profile options to the users as required.
• Created models for new database development and/or changes to existing ones.
• Installed and configure relevant network components to ensure database access as well as database consistency and integrity.
• Responded to and resolve database access and performance issues.
• Monitored database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
• Designed and implemented redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.
• Monitored, optimize and allocate physical data storage for database systems.
• Planned and coordinated data migrations between systems.
• Developed, implemented, and maintained change control and testing processes for modifications to databases.
• Interacted with analysts and technical support.
• Understand networking concepts, security, and administration and hardware configuration.
• Migrated data across different databases and platforms.
• Tasked with creating new database platform from scratch to production and Excel file to SQL Server Migration. Reports, forms. DB design, data modeling. SQL Server to Web.
• Granted administration.
• Database systems merged.
• Data was cleaned and imported.

Confidential - Kansas City, MO

SQL Database Administrator

Responsibilities:

• 2000, 2005, 2008R2, 2012 R2 and MS SQL 2014 Clustering and AlwaysOn platforms.
• Provided cluster and data center database administration and operational support and problem resolution.
• Worked directly with various vendors, with technical partners, key stakeholders, support long-term strategic direction, roadmaps, new capabilities, processes, and services.
• Managed 100+ SQL Servers (4000+ DBs) with max size of 2.5 TB.
• Successfully Installed\migrated\upgraded multiple SQL Server 2000, 2005 and 200·8R2 (100+ instances, 3000+ databases) to SQL Server 2012 and 2014.
• Decommissioned the old databases, instances and cleaned up the disk spaces and back to the production again.
• Strong understanding & hands on experience with Windows 2012 cluster services (2-5 Node clusters) for production databases.
• Hands on experience with Performance Tuning, DB Growth Monitoring and troubleshooting SQL Server related issues.
• Automated dropping and recreating replication after each database refresh.
• Implemented scheduled patch releases & database server’s maintenance with coordination of other support groups.
• Worked with project managers & development teams to support & implement business projects.
• Participated in COB exercise as DBA coordinator,
• Participated in CAB calls to review & approve scheduled changes. Perform standard DBA activities on Prod/UAT/DEV servers. (Users & Roles Administration, Refresh Training DB’s, Trained new hire’s, Process/Technical documentation etc.
• Expertly performed software installation, upgraded, configured, administered, automated and optimized MS SQL cluster architectures and associated software - providing a secure, reliable and highly available data base platform to MCEITS Data Center customers and services.
• MS SQL Server 2012 AlwaysOn Availability Groups platforms.
• Applied best practice for tuning SQL databases to improve overall system performance.
• Created and maintained all SQL databases required for development, testing, and production usage.
• Performed planning and assists application developers and System administrators, to ensure that any new SQL products or release upgrade takes place with minimal impact
• Troubleshot all problems regarding SQL databases, applications and development tools.
• Created new SQL databases as required, enforced and maintained database constraints to ensure integrity of the SQL database.
• Maintained database availability including backup and recovery, system security and auditing support.
• Performed with database patching.
• Integration of databases with custom applications, interfaces and COTS products.
• Provided technical expertise as a database administrator; participate in the formulation of database engineering best practices; assess feasibility of data models; performance tuning queries; and documentation of database processes and standards.
• Applied STIGs SIPR and NIPR in Instance and Database level. Create the STIGs documentation and report for further use and auditing purpose. Environment: Windows Server 2012/ 2008 R2 and 2003R2, IIS 7.5, 7.0 and 6.5, SQL Server 2014, 2012, 2008R2, 2008 and 2005. SharePoint 2010.