The Database Administrator provides support to the United States Patent and Trademark Office (USPTO), Knowledge Management Support Services (KMSS). This position solves complex problems / challenges to improve the reliability and performance of the database environment. Specifically, this position will be responsible for daily maintenance, monitoring, performance analysis, troubleshooting, problem resolution, reporting and user assistance required to enhance the services platform.
ESSENTIAL DUTIES AND RESPONSIBILITIES
Essential duties and responsibilities include the following. Other duties may be assigned.
Responsible for the integration of CNI Core Competencies into daily functions, including: commitment to integrity, knowledge / quality of work, supporting financial goals of the company, initiative / motivation, cooperation / relationships, problem analysis / discretion, accomplishing goals through organization, positive oral / written communication skills, leadership abilities, commitment to Affirmative Action, reliability / dependability, flexibility and ownership / accountability of actions taken.
Performs day-to-day database maintenance, including data archival, data recovery, anomaly detection and data entry.
Develops systems and process to monitor data integrity issues.
Defines and champions database best practices.
Troubleshoots and resolves operational problems.
Tests new applications and procedures. Corrects data as required and provides feedback to appropriate personnel.
Accumulates and stores data from diverse sources.
Analyzes information, runs queries to ensure accuracy and generates regular and customized reports.
Creates reports as may be required of system data problems.
Proactively reviews and improves overall system data processes to ensure high integrity of information.
Monitors quality assurance efforts.
Ensures the information provided is consistent, timely, and accurate.
Responsible for aiding in own self-development by being available and receptive to any training made available by the company.
Plans daily activities within the guidelines of company policy, job description and supervisor’s instruction in such a way as to maximize personal output. Responsible for aiding in own self-development by being available and receptive to all training made available by the company.
Responsible for keeping own immediate work area in a neat and orderly condition to ensure safety of self and coworkers. Will report any unsafe conditions and/or practices to the appropriate supervisor and human resources. Will immediately correct any unsafe conditions to the best of own ability.
Bachelor’s degree in a related field of study and three (3) years’ of experience; or equivalent combination of education / experience. Basic experience in one or more management information system concepts, or information science concepts, such as general computing, database structure and programming languages, Microsoft
Access and Visual Basic for Applications, Microsoft SQL and Oracle or UNIX-based systems (such as CUADRA STAR) required.
CERTIFICATES / LICENSES / REGISTRATION
JOB SPECIFIC KNOWLEDGE / SKILLS / ABILITIES
Knowledge in Microsoft Access and Visual Basic for Applications, Microsoft SQL and Oracle or UNIX-based systems (such as CUADRA STAR)
Knowledge of database concepts, object and data modeling techniques and design principles with an understanding of different data structures and their benefits / limitations under particular use cases
Knowledge of software programming, development, review, audit, testing, configuration management requirements and changes
Knowledge of computer hardware, systems software, and computer systems architecture and integration
Ability to work independently or as part of a cross-functional team
Excellent communication and documentation skills
Excellent critical thinking and problem-solving skills
Detail-oriented with ability to prioritize tasks
Ability to read, analyzes, and interprets general business periodicals, professiona1journals, technical procedures, or governmental regulations. Ability to write reports, business correspondence, and procedure manuals. Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public.
Ability to work with mathematical concepts such as probability and statistical inference, and fundamentals of plane and solid geometry and trigonometry. Ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations.
Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this job. Work is primarily performed in an office environment. Regularly required to sit. Regularly required use hands to finger, handle, or feel, reach with hands and arms to handle objects and operate tools, computer, and/or controls. Required to speak and hear. Occasionally required to stand, walk and stoop, kneel, crouch, or crawl. Must frequently lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision, depth perception, and ability to adjust focus. Exposed to general office noise with computers printers and light traffic.