What are the responsibilities and job description for the Database Administrator position at CTG, Inc.?
CTG is seeking to fill a Database Administrator opening for our client in Los Alamos, New Mexico.
Location : Los Alamos, NM
Duration : 3 to 6 months
Under general supervision of the Chief Information Officer or designee, provides technical expertise in the design, implementation, and maintenance of relational database management systems (SQL and Oracle) that support institutional business applications. Ensures logical data models are mapped effectively and efficiently into physical data models that take advantage of the characteristics of the specific database management system used. Responsible for technically supporting multiple databases that run countywide business applications which are accessed by multiple departments. Maintains confidentiality of all privileged information.
Essential Duties and Responsibilities :
Reviews, develops, and designs data models using standard diagramming techniques; creates logical data models and translates into physical database structures that integrate with existing or proposed database structures.
Monitors relational databases to optimize database performance, resource use, and physical implementations of databases; addresses a variety of database integration issues including migration between disparate databases, integration, maintenance / conversion, capacity planning issues, and new applications.
Maintains multiple development, test and production database environments.
Monitors and maintains database security and software, in cooperation with systems administrators.
Ensures support is provided to customers in a professional, courteous, and timely manner.
Provides recommendations to applications analysts in the effective use of database languages; advises on troubleshooting, exception processing needs, and other data management issues.
Develops and manages multiple linked databases to include security, data safety and integrity, disaster recovery, and development and implementation of bulk data import / export procedures.
Responsible for coordinating and managing technology projects of varying complexity, on time and within budget.
Maintains availability and integrity of databases through multiple access schemes; facilitates sharing of common data by overseeing proper key and index management and data dictionary maintenance.
Evaluates and recommends testing of new database related procedures, software, and hardware.
Monitors and manages database backups, logs, and journals; installs, maintains, and upgrades database software; restores and / or recovers data.
Creates, procures and maintains various database related documents such as manuals and programmers handbooks.
Maintains a broad knowledge of state-of-the-art technology, equipment, and / or systems; participates in professional development activities.
Ensures strict confidentiality of all information and records.
Contributes to a team effort and accomplishes related results as required.
Performs other duties as required.
Minimum Qualifications :
Bachelor's Degree from an accredited college or university in Computer Science, Information Technology, Management Information Systems, Library Information Systems or related field or equivalent combination of education and related work experience.
Eight to ten years of experience in database management, troubleshooting and customer support experience.
Must possess current Oracle Database or Microsoft Database certification.
Must have PowerShell experience.
Preferred Qualifications :
Both Oracle DBA Certification and MS SQL Server Certification.
Master's Degree from an accredited college or university in Computer Science, Management Information Systems, Library Information Systems or related field.
PMP certification or equivalent.
Valid New Mexico driver's license.
Knowledge, Skills, and Abilities :
Knowledge of current technological developments / trends.
Knowledge of federal copyright laws as they pertain to the use of computer software.
Knowledge of computer security procedures and protocol.
Knowledge of data integrity methods and techniques.
Knowledge of computer and / or network security systems, applications, procedures, and techniques.
Knowledge of standard Microsoft desktop applications, Oracle and SQL server / databases.
Skill in managing projects, in planning and adhering to schedules, and in working as an individual contributor and a team member.
Skill in technical writing and documentation.
Skill in report writing and programming.
Skill with business intelligence software.
Ability to provide technical guidance and leadership to professional personnel in area of expertise.
Ability to interpret data models and to develop database structures.
Ability to use standard diagramming techniques to design and develop computer data models.
Ability to implement and troubleshoot programming changes and modifications.
Ability to program, configure, manage, and maintain the operation of complex relational databases.
Ability to develop and manipulate large, complex data sets.
Ability to establish and maintain professional relationships with individuals of varying social and cultural backgrounds and with co-workers at all levels.
Ability to install, maintain, modify, and upgrade database software.
Ability to perform acceptance testing on computer systems, applications, and hardware.
Ability to act in an independent and conscientious manner using sound judgment and memory.
Ability to be analytical, highly organized, self-motivated, and client-oriented.
Ability to communicate effectively, both orally and in writing.
Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required.
CTG does not accept unsolicited resumes from headhunters, recruitment agencies, or fee based recruitment services for this role.
To Apply :
To be considered, please apply directly to this requisition using the link provided. For additional information, please contact Laura Dominguez at 716-887-7203 or laura.dominguez@ctg.com . Kindly forward this to any other interested parties—thank you!
About CTG
CTG, a Cegeka company, is at the forefront of digital transformation, providing IT and business solutions that accelerate project momentum and deliver desired value. Over nearly 60 years, we have earned a reputation as a faster and more reliable, results-driven partner. Our vision is to be an indispensable partner to our clients and the preferred career destination for digital and technology experts. CTG leverages the expertise of over 9,000 team members in 19 countries to provide innovative solutions. Together, we operate across the Americas, Europe, and India, working in close cooperation with over 3,000 clients in many of today's highest-growth industries. For more information, visit www.ctg.com .
Our culture is a direct result of the people who work at CTG, the values we hold, and the actions we take. In other words, our people define our culture. It's a living, breathing thing that is renewed every day through the ways we engage with each other, our clients, and our communities. Part of our mission is to cultivate a workplace that attracts and develops the best people, reflected by our recognition as a Great Place to Work Certified™ company across many of our global operations.
CTG will consider for employment all qualified applicants including those with criminal histories in a manner consistent with the requirements of all applicable local, state, and federal laws.
CTG is an Equal Opportunity and Affirmative Action Employer. CTG will assure equal opportunity and consideration to all applicants and employees in recruitment, selection, placement, training, benefits, compensation, promotion, transfer, and release of individuals without regard to race, creed, religion, color, national origin, sex, sexual orientation, gender identity and gender expression, age, disability, marital or veteran status, citizenship status, or any other discriminatory factors as required by law. Our Affirmative Action program serves to promote occupational equality and diversity through good faith efforts. CTG is fully committed to promoting employment opportunities for members of protected classes.
