Database Administrator (Dba)

Jenzabar Harrisonburg , VA 22801

Posted 2 days ago

This is a permanent, full-time position.

Summary of Position
SQL query, stored procedure, trigger, function, and view creation and debugging. Create and execute database structure and data enhancement scripts as required to meet development goals. Create database designs to meet development goals. Monitor and optimize system performance using index tuning, disk optimization, and other methods. Install, configure, troubleshoot, and maintain a database system. Implement, configure, and troubleshoot database instances, replication, backup, partitions, storage, and access. Set user privileges within the database environment.
Essential Tasks
Update and maintain all databases utilized by product development staff, across multiple versions of the software.
Work with the design and development team to produce database designs that meet the specified requirements. Perform database modeling and can communicate that model to the development staff to ensure they understand the schema against which they are developing.
Work with the Quality Assurance team to test and verify delivery of database changes for software releases.
Works as needed with the support team to help resolve difficult database issues in our customer base.
Works as needed with the data services team to answer any questions or help with difficult technical issues faced during conversion.
Stay current with upcoming versions of Microsoft SQL Server and be aware of changes that will affect the software.
Essential Skills
Complete proficiency in SQL DML, DDL, and DCL commands, proficient coding skills in triggers, views, and stored procedures, and code optimization. Ability to design and code complex procedures, triggers, and views. Thorough understanding and execution of all SQL database administration tasks. Thorough understanding of database delivery concepts (structures and data) with the ability to execute this process in a multi-server environment (deployment to hundreds of customer systems).
Thorough understanding and ability to create and maintain SQL permissions.
Thorough understanding and ability to install, configure, troubleshoot, and maintain a Microsoft SQL Server database system.
A thorough understanding of relational database concepts and techniques, and the ability to code the implementation via SQL DDL. Ability to gather design requirements from\with software product managers and architects. Ability to design relational database objects to meet software design goals.
Education
Bachelor's degree in Computer Science or related field.
Preferred Skills and Experience
Must have current experience with database administration using Microsoft SQL Server technologies including Microsoft SQL Server 2014+. Solid knowledge of and experience with scripts required to manage an SQL environment.
Proficient in writing complex T-SQL statements, stored procedures, triggers and views. Need to assist development staff as needed with complex queries and well-performing SQL statements to ensure the proper performance of the system.
Experience with data import/export, data conversions, and database patch applications.
Excellent oral and written communication skills in order to communicate effectively with development staff and clients of varying technical expertise.
Have strong organizational skills-being able to plan, coordinate, and track tasks effectively with a demonstrated history of meeting project deadlines.
Experience with Microsoft Active Directory and working in an academic environment or with higher education software are all desirable.

Benefits

Medical Insurance, Life Insurance, Dental Insurance, Vision Insurance, Paid Vacation, Paid Sick Days, Paid Holidays, Short Term Disability, Long Term Disability, 401K/403b Plan, Educational Assistance

See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Help Desk Administrator

Jenzabar

Posted Yesterday

VIEW JOBS 11/13/2018 12:00:00 AM 2019-02-11T00:00 <p><strong>POSITION SUMMARY</strong></p> <p>The IT Help Desk Administrator is responsible for the daily tasks related to end user support. The primary goal is to ensure interruption free service delivery from the IT department’s systems. Additionally, this position functions as the primary support contact for end-users, handling all support requests, documenting received requests, troubleshooting, resolving, and following up with end-users to ensure issues are resolved properly.</p> <p>Day-to-day duties might include but are not limited to:</p> <ul> <li>Provide technical support and service for all end users </li> <li>Maintain service through telephone, remote access, and in-person when appropriate </li> <li>Troubleshoot basic network problems (DHCP, DNS) </li> <li>Work with Director of IT to recommend training programs based on calls to better assist end users </li> <li>Learn and keep current with all new software applications used in the environment</li> <li>Enforce policies and procedures for end users use of technology </li> <li>Assists with training of associates by educating users on basic PC computing skills.</li> <li>Maintains customer confidence and protects operations by providing a high degree of professionalism and customer satisfaction. </li> <li>Ensures issues are resolved by escalating issues as needed</li> <li>Maintains accurate record keeping by ensuring that all problems are properly documented. </li> <li>Contributes to team effort by accomplishing related results as needed. </li> <li>Maintains, analyzes, troubleshoots, and repairs computer systems, hardware and computer peripherals. </li> <li>Documents, maintains, upgrades or replaces hardware and software systems. </li> <li>Supports and maintains user account information including rights, security and systems groups</li> <li>Has knowledge of commonly used PC and Windows concepts, practices, and procedures. </li> <li> Monitors network and associated devices for potential issues. Reports any findings to manager for further direction.</li> </ul> <p></p> <p></p><p><em><strong>QUALIFICATIONS</strong>:</em></p> <p></p> <p><em>Education:</em> </p> <ul> <li>Bachelor’s Degree in Information Technology or Similar Preferred </li> <li>Technical training acceptable </li> <li>High School Diploma required</li> </ul> <p></p> <p><strong><i>Desired Experience:</i></strong></p> <ul> <li>At least 1-year experience in a Help Desk/Technical Support environment required (Experience can include student work, CO-OP, etc.)</li> <li>Strong PC skill and Windows 10 knowledge Mac OS experience a plus </li> <li>Understanding of Networking Fundamentals </li> <li>Active Directory Administration (user/permission setup and management) </li> <li>Ability to troubleshoot and resolve issues remotely </li> <li>Desktop/Laptop backup </li> <li>Advanced Knowledge of Office applications (Word, Outlook, PowerPoint and Excel) </li> <li>Basic Networking and WiFi setup familiarity </li> <li>Good interpersonal skills </li> <li>Highly Organized </li> <li>Office 365 Experience (Exchange Online, SharePoint, OneDrive) </li> <li>Basic Client-Server understanding</li> <li>Experience with inventory/asset management </li> <li>Familiarity with VoIP phone systems</li> <li>Ability to assist users on mobile devices (iOS and Android)</li> </ul> Jenzabar Harrisonburg VA

Database Administrator (Dba)

Jenzabar