Administer, test, and implement MS SQL Server databases, applying knowledge of database management systems. Coordinate changes to computer databases. Plan, coordinate and implement security measures to safeguard computer databases. Create and review database designs and databases with proper index architecture related code. Assist development team with specifications and requirements regarding data and database design following standards and best practices.
Must be competent in capacity and performance monitoring as well as tuning of SQL servers; troubleshoot server and database problems; maximize performance and tuning of all SQL servers. Understand execution plans.
Perform normal administrative tasks, such as security and access management, support of scheduled jobs, support of backup and recovery jobs.
Design and build internal applications/processes to improve the administration and support of the database/application environment. Install and test upgrades and patches for the database servers and the database management tools in all environments.
Applicants must be a Microsoft Certified Solutions Associate (MCSA) with 5 years experience in SQL Server, SSRS and T-SQL Development.
Helpful skills include Wonderware Historian and OSIsoft PI Historian.
Candidates should be self-motivated and able to work with minimal supervision, demonstrate excellent problem solving, verbal and written communication skills. The applicant should function efficiently act as part of a larger development team.
- Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems, such as the installation of new databases.
- Develop data model describing data elements and how they are used, following procedures and using pen, template or computer software.
- Develop methods for integrating different products so they work properly together such as customizing commercial databases to fit specific needs.
- Develop standards and guidelines to guide the use and acquisition of software and to protect vulnerable information.
- Establish and calculate optimum values for database parameters, using manuals and calculator.
- Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.
- Modify existing databases and database management systems or direct programmers and analysts to make changes.
- Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
- Review procedures in database management system manuals for making changes to the database.
- Review project requests describing database user needs to estimate time and cost required to accomplish the project.
- Review workflow charts developed by programmer analyst to understand tasks computer will perform, such as updating records.
- Revise company definition of data as defined in the data dictionary.
- Select and enter codes to monitor database performance and to create production database.
- Specify users and user access levels for each segment of database.
- Test programs or databases, correct errors and make necessary modifications.
- Train users and answer questions.
- Work as part of a project team to coordinate database development and determine project scope and limitations.
- Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.
- Analyze data to identify trends or relationships among variables.
- Assess database performance.
- Coordinate project activities with other personnel or departments.
- Coordinate software or hardware installation.
- Create databases to store electronic data.
- Develop computer or information security policies or procedures.
- Develop database parameters or specifications.
- Develop detailed project plans.
- Develop guidelines for system implementation.
- Develop models of information or communications systems.
- Develop performance metrics or standards related to information technology.
- Estimate time or monetary resources needed to complete projects.
- Implement security measures for computer or information systems.
- Modify software programs to improve performance.
- Read documents to gather technical information.
- Train others in computer interface or software use.
- Update computer database information.
- Write computer programming code.