Remote Database Administrator Resume Richmond, Virginia - Hire IT People

SUMMARY

A Database Professional wif solid technical experience maintained and developed all aspects of SQL Server Databases (2014, 2012, 2008/R2 and 2005) including administering, developing objects, data modeling, developed and maintained reports using SQL Server Reporting Services (SSRS) including other database objects like stored procedures, triggers, views, functions, constraints. My broad general skills include:

TECHNICAL SKILLS

Database Tools: MS SQL Server 2008/2012/2014, SSIS 2008/2012, SSRS 2008/2012, MS Access 2007, Oracle

Programming Languages: T - SQL

Development Environment: SQL data tool, Visio, DB Designer.

Reporting Tools: Excel 2007 and 2016, SSRS.

Third Party Tools: RedGate Backup tools, RedGate Data compare tools.

Operating Systems: Windows Server 2008, 2012, 2014, linux, and Unix

Software: VMWare, Microsoft Office, QTP, QC, STEP 7/ STEP 7 Micro Win, PL7, Freelance 2000.

PROFESSIONAL EXPERIENCE

Remote Database Administrator

Confidential, Richmond, Virginia

Responsibilities:

Design SQL Server databases and provide initial consultations to the customer prior deployments to the production environments.
Maintaining Enterprise Data Warehouse infrastructural and support production and test deployments.
Building AlwaysOn Availability Group
Implementing database upgrade to higher versions.
Configuring and implementing database security processes.
Configuring and implementing maintenance plan for all databases.
Maintain SQL Server 2014 High Availability AlwaysOn in AZURE Environment
Administer production backend databases for the company's web applications
Design and created databases on MS SQL Server 2008r2, 2012 and 2014.
Designed and implemented a comprehensive Backup plan and disaster recovery strategies.
Create and configured SQL Server mirroring process for the high availability.
Work on incidents tickets and implement solutions and root cause analysis report.
Provide 24x7 dedicated production support for SQL Server problem resolution and server outages.
Participate in weekly change management meetings to review scheduled deployments.
Performed SQL Server Risk Assessment Process (SQLRAP).
Administered MAP (Microsoft Assessment Planning) Toolkit for building inventory of the databases.
Planned and coordinate data migration between databases across the organization.
Implemented monitoring process for all jobs in test and production environments.
Deployed and maintain SSIS packages for the ETL processes.
Deployed rdl files for the reporting portal (SSRS).

Database Administrator

Confidential, Washington, D.C

Responsibilities:

Providing 24x7 dedicated production support for SQL Server problem resolution and server outages.
Installed, Configured, and Managed SQL Server 2012, 2008R2, 2008 & 2005 in development, test, and production environment
Installed and Configured SQL Server 2008/R2 for testing different features and stability
Database Upgraded (development, testing and production environment):
SQL Server 2005 to 2008/2008R2 o SQL Server 2008 to SQL Server 2008R2, 2012
Database Migrated (development, testing and production environment)
MS Access databases into MS SQL Server 2005, 2008, 2008R2 and 20012 o Oracle databases to SQL Server 2008
Worked on more than 10 data modeling projects and generated E-R Diagram o Data Modeling tools used: ER M n, VISIO, SQL Server Data Diagram
Database Monitoring/Performance Tuning:
Strong on database Monitoring and Performance tuning
Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
Export & Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP
Export & Import data from/to databases like Oracle, My-SQL, and Access to/from SQL Server
Strong knowledge and working experience in Database Backup and Disaster Recovery o Experienced wif Point-in-Time Recovery o Restored Database from backup
Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Developed Different Maintenance Plans for database monitoring
Monitor Server Activity, and solving problem as needed
Prepared documentations of all database procedures and guideline

Automation Engineer

Confidential, Washington, D.C

Responsibilities:

Assist wif Building Automation Engineers in analyzing, designing, configuring and programming Building Automation Systems (BAS) as defined by the project specification.
Monitor and inspect equipment (boilers, chillers, AHUs, RTUs, FCUs), computer terminals, switches, valves, gauges, alarms, and safety devices.
Monitor the chiller plant including, boilers, chemicals, fuel levels, and adjusting required levels through the Automation Management System (AMS).

We provide IT Staff Augmentation Services!

Remote Database Administrator Resume

Richmond, VirginiA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship