We provide IT Staff Augmentation Services!

Sql Database Administrator (secdef, Dod) Resume

5.00/5 (Submit Your Rating)

SUMMARY:

  • I have over seven years of relational and object - relational database management and administration, analysis, design and architecture of E-Commerce, Web-based, distributed and client/server environments: Installed, configured, created and managed Oracle and MS SQL databases. Also, I have nine years’ experience that includes network design, operational support, hands-on implementing and configuration of network devices such as servers, routers, hubs, switches, UPS, desktop computers, and cabling in a large LAN/WAN environment. In charge of daily Veritas Backup Exec
  • Upgraded Oracle from lower to higher versions, moved databases from one server to other servers dedicated for testing. I have also, created and configured listeners for applications, database users including assigning users with appropriate roles based on privilege levels. Conduct surveys to define system scope and functionality to manage user expectations.
  • I have administered maintained, developed, and implemented policies and procedures for databases. In addition, I’ve Implement data models, database designs, ensure data access, and tune databases. Ensure acceptable database performance, help in capacity and disaster recovery planning.
  • Develop and formulate standards, procedures, and conventions for database use. Determine file organization, indexing methods, and security procedures for specific user applications. Installing, configuring, and upgrading Oracle Software on servers and client machines.

TECHNICAL SKILLS:

Databases: Oracle 10g DBMS, SQL PL/SQL*Plus, Access Crystal Reports

Software: HEAT, Citrix, TOAD Remedy Heat Database call logging and Tracking, Dreamweaver, MS Office, Visio

PROFESSIONAL EXPERIENCE:

Confidential

SQL Database Administrator (SecDef, DOD)

Responsibilities:

  • As a SQL Database Administrator, I provided day to day administration, including actively monitor, troubleshoot& support in an enterprise environment.
  • Check OS Event Logs and SQL Server Logs for unusual events.
  • Verify that all scheduled jobs have run successfully. Confirm that backups have been made and successfully saved to a secure location.
  • Monitor disk space to ensure your SQL Servers won’t run out of disk space. For best performance, all disks should have 15% or more of free space.
  • Throughout the day, periodically monitor performance using both System Monitor and Profiler/SQL Trace. Regularly monitor and identify blocking issues.
  • Keep a log of any changes you make to servers, including documentation of any performance issues you identify and correct.
  • Build and maintain documentation for easy and deliverables as requested.
  • Fail over and Patch VERITAS clustered nodes on Windows Servers during regular service patches and interval update cycles.
  • Create and monitor and configure maintenance plans and jobs
  • Truncate SQL Log files and rebuild indexes when needed for optimized database performance.
  • Other Duties include: Develop contingency plans (Disaster Recovery or Business Continuation Plans for information technology systems) to ensure availability and accessibility of network resources.
  • Develop long-range plans for IT security systems, identify, evaluate, mitigate, and minimize risks associated with IT systems vulnerabilities.
  • Implement security requirements, integrate security programs and define the scope and level of detail for security plans and policies

Confidential

SQL Database Administrator (OSD,DOD)

Responsibilities:

  • Serves as a member of a Database Administration Team providing support for SQL Server 2005 and production support of Oracle 10g/11g databases in a windows server clustered environment.
  • Responsible for the installation, configuration and administration of MS-SQL Server Databases. Provides technical expertise in data models, Entity Relational Diagrams and database performance tuning for the Application Team.
  • Experience in creating and maintaining backup / recovery and Disaster Recovery procedures.Work within a team environment to implement customized solutions to support customer requirements. Support the Oracle and MS SQL Server Development, Test and Production environments.
  • Complete scheduled and unscheduled outages as required to support the production environment.

Confidential

Systems Administrator/Oracle DBA, (DC Gov)

Responsibilities:

  • Build, installed, Implement and configured ACCELA which is customized Software which integrates multiple Databases, Applications and Departments within DCRA to work together as one sound system.
  • Build maintained and configured multiple Servers on Windows platform. I Helped Supervise 100 end users, who used Oracle and various customized programs. Used Dame Ware, LANDesk, and Remote Desktop to effectively troubleshoot programs connectivity to shared network resources while making sure programs are running at their peak performance levels. Create Grant and Modify user roles on Windows 2003 AD.
  • Installed test and configured multiple Network Printers including Ricoh and Dell brands, while making sure users can print successfully to them.

Confidential

Oracle Database Administrator/Systems Administrator (DOD/DISA)

Responsibilities:

  • I install and create database instances and deploy them. I administer databases in development, test and production environments. Design, evaluate, and implement database applications to accommodate a variety of user needs.
  • Analyze and determine informational needs and elements, data relationships and attributes, proposed manipulation, data flow and storage requirements, including data output and reported capabilities to the users department.
  • Perform administration duties related to the modeling, design, development, configuration, and maintenance of application databases. Develop and maintain Entity Relationship Diagrams (ERD).
  • Develop database access methodologies, routines, and processes.
  • Perform systems-level database maintenance. Worked in a Classified/Unclassified environment as a Systems/Server Administrator, which I Added modified and disabled user accounts within Active Directory in a Windows 2003 Server Environment.

Confidential

System Administrator

Responsibilities:

  • Installs, Build, implement and deploy Windows 2000/2003 Server and Workstation, including setting up Active Directory services on new domains.
  • Install and configure Printers, Users and Software.

Environment: Outlook Client, Crystal Report, Citrix Client, ADP software including Report Smith.

We'd love your feedback!