Diverse Technologies Company
  • Harrisburg, PA, USA
  • Full Time

The Senior Database Developer provides technical expertise in a variety of technical areas in the support of JNET's system applications.  The individual in this position is responsible for providing Data Analysis and Database Administrative (DBA) functions for JNET Application Support Team as well as the JNET Development Team.

Work closely with the JNET Business Analyst (BA) and Application Developers to ensure they have all the required data elements properly defined and populated to provide accurate and timely results. This position also requires work closely with the Application Support team to assist in providing support to the JNET Applications Support Specialists and interface with Enterprise Data Center (EDC) Database Team.

1.1.1             Responsibilities

  • At the direction of JNET, and in conjunction with the Enterprise Data Center (EDC), responsible for infrastructure capacity planning to ensure that existing and new services have a stable platform for availability and support.
  • Conducting analysis of present methods, applications, objectives, and pertinent data, followed by the recommendation of proactive solutions using automated technology equipment and techniques, to produce the optimum and most economical solution to application needs that will ensure JNET's Service Level Agreements with agency stakeholders are met.
  • Managing the coordination between computer design, programming, database, data communications, software, and operations functions to ensure that responsive and satisfactory service levels are established and maintained for the 24 hours per day 7 days a week and 365 days per year support.
  • Developing, recommending, arranging and/or conducting training of hardware systems and software applications as required to maintain JNET's four environments.
  • Assisting JNET management with highly complex application project development and completion.
  • Providing technical assistance in a centralized support capacity as well as advising JNET's management team in the design, acquisition, installation, operation, and maintenance of JNET's applications, infrastructure, security and networks.
  • Interacting with EDC Database Support in the installation and maintenance of any host software and hardware necessary to support the JNET environment.
  • Implementing, controlling, and monitoring JNET's data security measures.
  • Recommending JNET security policy, procedures, and guidelines for the protection of computer assets, confidentiality, and integrity of information.
  • Investigating, analyzing, and resolving end-user security and resource access control problems by working closely with application developers and/or database analysts to provide the most secure and efficient methods of protecting online transactions and information accessed through JNET's messaging, client-server and web-based applications.
  • Serving as a team member or project lead on highly complex departmental or interagency systems development projects that involve critical business processes, numerous variables and diverse operational requirements.
  • Ensure completion of all assigned tasks on or before the assigned tasks due dates.
  • Provide honest, thoughtful, timely, and reasonable work and time estimates. 
  • Provide honest, regular, accurate, and timely statuses for all assigned tasks and work.
  • Identify all tasks you cannot complete or meet assigned dates and clearly communicate them to the Project Manager(s) and your Functional Manager.
  • Clearly, effectively and frequently communicate with the Project Manager(s) and your Functional Manager for all assign work tasks.
  • Meet all of your Functional Manager or Lead's expectations regarding the quantity and quality of your work.
  • Work cooperatively with all JNET teams and team members
  • Actively participate in all assigned project and team meetings. If you cannot attend a Team Meeting, inform your Project Manager(s) and Function Manager in advance.
  • Arrive at meetings on or before the scheduled start time.
  • Be prepared for all assigned agenda items in meetings.
  • Read materials provided in advance of meetings and be prepared to provide input, ask questions, and make recommendations.
  • Develop, modify and complete all reporting and timesheets in a timely manner.
  • Resolve all issues in a timely manner.
  • Develop, update and maintain a desk manual to facilitate detailed transition of work.
  • Provide knowledge transfer to designated Commonwealth staff or other contracted staff.
  • Provide mentoring and training to other staff as assigned.
  • Perform additional duties as assigned.

 

1.1.2             Desired Education, Knowledge, Skills and Abilities

  • Five years of experience with database administration and development. This includes, but not limited to, designing databases and implementing database applications, both transactional databases and data warehouses.
  • Working knowledge of the Microsoft SQL Server tools (SQL Server Configuration Manager, Management Studio, Data Tools, Analysis Services, Surface Area Configuration, Dynamic Management Views, and Tuning Advisor).
  • Strong experience using SQL Server Management Studio to create SSIS packages.
  • Strong experience using SQL Server Reporting Service in developing and generating reports.
  • Professional experience with performance tuning and query optimization using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
  • Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log issues, connectivity issues, security issues, etc.
  • Experience in creating database architecture with associated schema as part of a software design process
  • Knowledge of information technology and systems analysis principles and techniques.
  • Knowledge of computer programming techniques.  Knowledge of developments and practices in application development and methodologies, including computer assisted systems engineering, rapid application development, and shared application development approaches.
  • Experience with Java EE development is preferred.
  • Knowledge of the principles and techniques of application development documentation and strategies.
  • Ability to review and evaluate new technologies and application support tools for use in the application development process and to recommend the acquisition of new hardware and software for use in the application support process.
  • Knowledge of the basic concepts of networking.
  • Ability to review and prioritize requests for application support or modification and to resolve conflicting requests for service.
  • Ability to communicate effectively, orally and in writing.
  • Ability to effectively communicate complex technical issues to technical and non-technical staff.
  • Ability to establish and maintain effective working relationships with clients, associates, managers, vendors, and others.
  • Ability to write technical analysis and recommendations.
  • Critical thinking skills for using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.
  • Complex problem solving skills for identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.
  • Active learning skills for understanding the implications of new information for both current and future problem-solving and decision-making.
  • Troubleshooting skills for determining causes of operating errors and deciding what to do about it.
  • Knowledge of the use and interpretation of diagnostic utility programs used in troubleshooting problems.
  • Ability to elicit information from employees in order to diagnose and troubleshoot problems associated with information technology hardware and software.
  • Ability to provide assistance and support to employees in the use of software application programs and hardware devices.
  • Ability to utilize diagnostic utility programs in troubleshooting hardware and software problems. 
  • Judgment and decision making skills for considering the relative costs and benefits of potential actions to choose the most appropriate one.
  • Technology design skills for generating or adapting equipment and technology to serve user needs.
  • Reading comprehension skills for understanding written sentences and paragraphs in work related documents.
  • Operations analysis skills for analyzing needs and product requirements to create a design.
  • Systems analysis skills for determining how a system should work and how changes in conditions, operations, and the environment will affect outcomes.

 

Senior Database Developer Essential Functions:

  • Test and maintain business software applications.
  • Formulate and define application scope and objectives and devise and enhance procedures to solve business problems of a complex to highly complex nature.
  • Ability to interact at all levels of the organization.
  • Proficient with Microsoft Office tools (including but not limited to; Word, Excel, Access, Outlook, Visio, Project, etc).
  • Ability to work cooperatively with all levels of staff.
  • Capacity for organization, prioritization, and management in a dynamically changing environment.
  • Establishes rapport with users and promotes independent computing.
  • Problem solving skills, strong conceptual and analytical skills.
  • Ability to work independently and with self-motivation.
  • Excellent verbal and written communications skills.
Diverse Technologies Company
  • Apply Now

    with our quick 3 minute Application!

  • * Fields Are Required

    What is your full name?

    How can we contact you?

  • Sign Up For Job Alerts!

  • Share this Page
.
Logo About Us What We Do Our Clients Capability Statements Careers Contact Us Linkedin FB Employee Login Contract Vehicles Seaport E