We provide IT Staff Augmentation Services!

Associate Database Specialist, Database Specialist Resume

3.00/5 (Submit Your Rating)

SUMMARY:

Computer Science undergrad with background in different technology fields interested in gaining more IT and business experience. Recognizes that client satisfaction is key, and will work with staff to provide all possible support. Always willing to learn any skill not already possessed.

SKILL:

Familiar with the following Operating Systems: Windows Family (up to Windows 10), Ubuntu, RHEL 5 and 6, and Oracle Enterprise Linux. Experience with Linux system administration and relational database design. Experience with languages such as C, C++, C#, Python, Java, and SQL. Familiar with enterprise DBMS software such as Microsoft SQL Server, DB2, and Oracle, with enterprise DBA experience in all. Has scripting experience with Kornshell and bash. Has extensive knowledge of PC hardware as well as troubleshooting hardware and software issues. Has worked with Confidential PowerEdge tower and rack servers. Familiar with PC security, including website exploitations, networking security, and physical security. Knowledge of the following networking technologies: NAT, software and hardware updates across the network, anti - virus updates, RAID configurations, ActiveDirectory, DNS, DHCP, network printers, network cable troubleshooting, patch panels, switches, and group policies. Familiar with National Instruments cRIO FPGAs and PIC microcontrollers. Familiar with the following software packages: Apache, Eclipse, Foglight, AccessGrid, Ghost, CloneZilla, git, SQL Server 2008 Management Studio, SSRS, Matlab, SQL Plus, Visual Studio 2008, gcc, Microsoft Office (Word, PowerPoint, Excel), and OpenOffice.

EXPERIENCE:

Confidential

Associate Database Specialist, Database Specialist

Responsibilities:

  • Help administrate a large DB2 database environment, with over 200 databases in development, acceptance, and production regions.
  • Performed functions as both an applications DBA and operations DBA
  • Performed DB2 database upgrades, managed QREP, HADR, and frame based replication DR systems, performed DB2 client installs, analyzed job and jobstream impact through TWS, and looked at monitoring and systems analysis with Foglight as an operations DBA
  • Worked closely with application teams and BAs regarding DDL creation, query performance and tuning, and database architecting (such as using MQTs or partitioned tables) as an applications DBA
  • Re - wrote Kornshell script which scans DB2 databases for improper security settings and threats.
  • Mentored interns for both database administration and software development. Helped them learn fundamentals of both topics and guided them during the course of their projects
  • Designed stored procedures for a ported database from Access to SQL Server 2008. Stored procedures had to follow previous Access queries and were used for a front end designed with Reporting Services
  • Assisted in developing a front end for a DB2 database using Reporting Services. Helped troubleshoot several connectivity, communication, and data issues
  • Developed a Kornshell script that audited DB2 databases. Previous script was out of date with current security standards and several parts of the script had to be re-designed due to them not working or following incorrect standards
  • Documented all projects worked on, which detailed how to work with each developed system in detail for future personnel

Confidential

Junior System Administrator

Responsibilities:

  • Helped set up several clusters of virtual servers using Xen on various Confidential PowerEdge server racks. Included virtual servers for our website, wiki page, and inventory database
  • Established an AccessGrid network for the Confidential community. Allows staff and faculty to hold video conferences with other universities and institutions across the globe
  • Created an inventory database for every Confidential member and piece of equipment, which was later used to gather important security and user information for our network
  • Provided support functions for Confidential members which included diagnosing various PC, laptop, and printer problems

High Performance Computing System Administrator

Confidential

Responsibilities:

  • Duties include remote software installation on a 64 node (and 4 additional GPU outfitted nodes) cluster, as well as hardware maintenance, for use in CS research
  • Helped with physical maintenance of the cluster, and helped set up a switch for an internal network between each node of the cluster
  • Contacted software support as well as professors for assistance in installation of software

Confidential

Software Development Intern

Responsibilities:

  • Worked on a Buried Pipe Inspection project, which entailed finding corrosion in natural gas lines buried deep underground - was tasked with finding a critical angle needed for later calculations, and ended up using a program written in Matlab to find this angle
  • Developed a set of SQL reports using SQL Report Designer in Visual Studio 2005, which will be used by management to organize field service personnel
  • Developed a set of web pages with C# and ASP.NET which interfaces with database system - these pages will be used by management and authorized personnel to insert, remove, and update data in the database
  • Documented all projects worked on, which detailed how to work with each developed system in detail for future programmers and management personnel

Confidential

Help Desk Support

Responsibilities:

  • Worked with Ghost to image various desktop and laptop hard drives
  • Organized storage closets to ensure that all equipment, such as mice, keyboards, video cards, and laptops, was in correct place
  • Diagnosed various McAfee encryption software problems over phone with customers and network administrators
  • Diagnosed and fixed various desktop and laptop problems with individual professors, classrooms, and labs - have also contacted some professors over phone beforehand

Confidential

Network Administrator Assistant

Responsibilities:

  • Was introduced to how a network that serves over one thousand students and faculty was properly maintained and serviced
  • Saw how a Confidential PowerEdge server was maintained, how cable closets were maintained, and how patch panels were used and serviced. Also saw how network user questions and concerns were dealt with, as well as budget propositions and funding
  • Was allowed to create a miniature network with a spare server running Windows Server 2007, a switch, and two other computers. The server was set up using ActiveDirectory, group policies, and process DHCP and DNS requests

Confidential

Programmer and Lead Programmer

Responsibilities:

  • Worked with fellow students and volunteer engineers from Hamilton Sundstrand to successfully design, build, and test a robot using the C programming language on PIC microcontrollers
  • Later became lead programmer in charge of a student programming team. Used the LabView programming language on a National Instruments cRIO FPGA for our robot's control system
  • Also helped volunteer for several community events including: helping middle school students with their LEGO robot competitions, team fundraisers, and team demonstrations

We'd love your feedback!