Showing posts sorted by relevance for query Pasadena. Sort by date Show all posts
Showing posts sorted by relevance for query Pasadena. Sort by date Show all posts

Monday 14 July 2014

SQL Server & Oracle Database Administrator #15180 | Tetra Tech, Inc. | Pasadena CA US


SQL Server & Oracle Database Administrator #15180 | Tetra Tech, Inc. | Pasadena CA US


SQL Server & Oracle Database Administrator

Operating Unit : TES
Location : Pasadena CA US 91107
Career Level : Experienced (Non-Manager)
Education : Bachelor's Degree
Category : Information Technology
Job Description :
Tetra Tech is a leading provider of environmental and management consulting, engineering and technical services. We employ more than 14,000 people with 350 offices worldwide. We provide services to protect and improve the quality of life through responsible resource management, sound infrastructure, and rapid communications ability. We have a reputation for innovative design in the global design and construction industry. As part of the Tetra Tech family of companies, we are home to some of the best minds in the country, including nationally renowned subject matter experts. Whether we are contemplating the restoration of our environment or helping to revitalize our urban centers, we are thinking of clear sustainable solutions to resource management and infrastructure challenges. In fact, it's much more than what can be done today; it's what we'll be able to do tomorrow. We offer competitive compensation and benefits and are searching for innovative people to join our team.

 
SQL Server & Oracle Database Administrator
Tetra Tech is a looking for a self-motivated, skilled Database Administrator. This position initially will require 70% SQL Server and 30% Oracle database administrative duties and will adjust over time. It requires someone who is a senior level SQL Server DBA and a mid-level Oracle DBA. This position would be the link between the application and business teams and will facilitate database migration, consolidation, and daily system support from various offices into Enterprise Database Farms.

Job Requirements :
Minimum Requirements
Candidate shall have bachelor’s degree in computer science or information systems or minimum four years of technical experience in database administration or other technical field. Also, required to have four or more years of database administration experience in Microsoft SQL; two years of Linux Oracle database administration. Candidate should have sound time management and planning skills, good oral and written communication skills; and as needed manage small to medium size database projects in conjunction with working knowledge of Microsoft Office products.  
 
 
Job Essentials 
               Microsoft SQLSERVER
o   Installation, Administration and Maintenance of SQL Server Instances(2005-2012)
o   Troubleshoot various problems that arise in a day-to-day work and fix issues
o   Monitoring Server Error Logs and check email alert or configure email alerts
o   Create Users and assign permissions (internal or via active directory roles)
o   Create Linked Servers to SQL Servers and other databases such as Oracle, Access, Mysql 
o   Design or Enhance database Backup, Recovery Strategy, and Monitor their activities
o   Ability to Setup database failover, Clustering,  Mirroring, Log Shipping and Replication
o   Develop, implement, and monitor performance tuning tasks ( understand PowerShell)
o   Documenting changes and follow change control
o   Clone Development, Test, and Staging environments from Production instances  
o   Troubleshoot and solve various problems that arise in a daily DBA lifecycle.
o   Execute schema and code promotions  Dev ->Test ->QA ->Prod
o   Keep databases in synch ( replication , backup / restore , log shipping , Data Guard)
o   Works with application development staff in order to enforce standards, and quality assurance policies and procedures as it pertains to accessing corporate databases
Oracle Database ( additionally to Sqlserver)
o   Experience in Linux or Unix operating systems
o   Comfortable using vi or other non-gui programs and scripts
o   Installation, Administration and Maintenance of Oracle Database Rel 11g – 12g
o   Understanding and ability to navigate Oracle WEBLogic console
o   Understanding Oracle RAC and ability to troubleshoot  is desirable 
o   Working knowledge is a plus in various scripting languages (Perl, ksh, bash, php, JS)
o   Oracle ERP knowledge is a plus and R12 is highly desirable or recommended
o   Working knowledge of Oracle PL*SQL ( ability to write and debug)
Job Code : 177TES-SQL DBA ADMIN-MKG