Back to All Job Opportunities

Database Administrator
TEKsystems     Tucson, AZ 85702
 Posted 18 days    

**W2 ONLY**

Top Skills:

+ Oracle or Microsoft SQL

+ Oracle preferred

+ SQL server

Description:

Provide technical expertise in the design, implementation, and maintenance of relational database management systems (RDBMSs) and data integration systems that support corporate business applications. Responsible for the technical support of multiple database and middleware environments, from various vendors, that run company-wide business applications and which are accessed by multiple departments. Participate in a team environment that provides cost-effective IT data services to the various business units. Work closely with other areas of IT and the Project Management Office to create an efficient, fault tolerant environment for corporate data.

Position-Related Responsibilities

• Maintain development, test, and production RDBMS environments.

• Plan, install, maintain, modify, and patch or upgrade database software, middleware and associated toolsets.

• Maintain knowledge of state-of-the-art technology, equipment, and/or systems.

• Interact with vendor support to address and resolve issues.

• Recommend system architectures, participate in application data access layer development, configure databases, handle backup and recovery activities, monitor and tune systems, and produce reports.

• Monitor and tune relational databases to optimize their performance, resource usage, and their physical implementations for multi-terabyte Business Intelligence systems including partitioning, bitmap indexing and materialized views; addresses a variety of database integration issues, including migration of data between disparate databases.

• Participate in the integration, maintenance/conversion, capacity planning, and installation of databases for new applications.

• Monitor, tune and maintain application servers and middleware to ensure efficient operation.

• Develop scripts and programming to support automated database support processes.

• Prepare, administer and copy or clone production databases to test systems.

• Collaborate with system administrators to execute failover, fallback, disaster recovery, and other procedures for high availability and system tuning.

• Monitor and maintain, in cooperation with data security administrators, database security and database security software.

• Perform data management tasks as required for extracting, loading, transforming, editing and restoring data.

• Prepare and present audits and reports for management.

• Maintain availability and integrity of databases through multiple access schemes; facilitate sharing of common data by overseeing proper key and index management and data dictionary maintenance.

• Monitor and manage database usage by adding data files, extending tables, managing extents, performing reorganizations, etc.

• Evaluate and recommend testing processes and evaluate new procedures, software, and hardware.

• Perform database backups, monitor and manage database backup processes, logs, and journals; install, maintain, and upgrade database software; restore and/or recover data as required.

• Provide advice to applications programmers in the effective use of database access languages; advise on troubleshooting, exception processing needs, and other data management issues.

• Create and tune SQL code, PL/SQL, stored procedures and triggers.

• Assist developers with writing and tuning SQL queries.

• Create, procure and maintain various database related documents such as manuals and programmers handbooks.

• Create and maintain Unix shell scripts; particularly Korn shell scripts.

• Operate on a scheduled 24-hour on-call basis.

• Perform other job-related duties as assigned by management.

• Conform to corporate procedures and Information Services guidelines.

• Administratively report to a Group or Team Lead.

• This position may provide services to affiliates of the Company subject to the UNS Energy Code of Conduct and the related Policies and Procedures.

About TEKsystems:

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

  Back to All Job Opportunities

Job Details


Employment Type

Full Time

Number of openings

N/A


We strive to ensure that jobs posted on this website are true and accurate employment opportunities. The student/job seeker is responsible for verifying the legitimacy of employment opportunities before responding to, interviewing, or accepting positions.