Linux Administrator needed in Chicago, IL

Role Description:

• Datacenter Administrator/Systems Engineer to help manage one of the nation’s busiest SaaS applications
• The company offers an array of web-based software as a service (SaaS) products that can be deployed individually or as part of an integrated and comprehensive Management System
• Linux App servers and PG databases in a high-availability 24x7 data center
• Hardware/software configuration and management; lead hardware and software migration and upgrade efforts of varying size and complexity
• Install software, apply patches, manage file systems, monitor performance and troubleshoot alerts from commercial, open source & proprietary monitoring tools
• Manage DB maintenance and replication. Spot and rewrite problematic queries
• Business continuity planning

Required Skills:

• Bachelor’s degree or equivalent combination of education and experience
• 4+ years of Linux Administration
• In-depth knowledge of: Linux, PostgreSQL, Apache, LAMP environments
• Protocol level knowledge of SMTP/HTTP/HTTPS/IMAP protocols
• Strong troubleshooting skills
• Demonstrated initiative, customer orientation and team work
• Extensive professional systems maintenance experience in a Unix data center environment
• Some combination of the following skills: SAN, DBA, Basic Networking, Scripting, Python, Perl, Virtualization

Preferred Skills:

• Some SAN experience: EMC VNX or Clarrion a plus
• MS-SQL or MySQL experience a plus

Role Type: Direct Placement

Location: Chicago, IL

Feel free to contact me at mpeterson@theoris.com (you can attach your resume and preferred rate) or call 317-968-9844 if you’re interested in learning more details.

SQL Server DBA Permanent Role in Indianapolis

Role Title: SQL Server Database Administrator

Role Description:

• This is a highly technical DBA role dealing with: SQL/Database mirroring, installs, and building
• 24x7 on-call duties as this is a highly visible DBA role within the Engineering department and with executives
• Report to the Manager of IT Site Operations
• Responsible for ensuring that the company website is working and efficient
• Monitor and maintain production level database environments
• Identify and optimize poorly performing stored procedures and in-line SQL code
• Maintain disaster recovery plans as it pertains to the production database environment
• Train and mentor junior personnel on best practices
• Additional responsibilities as assigned

Required Skills:

• Knowledge of Microsoft Development Life-Cycle processes and procedures
• Knowledge in the maintenance planning on production systems and performance tuning (hardware and software)
• Knowledge of data replication, and, synchronization with external systems
• Knowledge of forecasting and growth plans as it pertains to hardware
• Technical skills including but not limited to: SQL, T-SQL, MS Office suite, Windows 7/Windows XP operating systems
• Installation and configuration of Microsoft SQL Server 2005 & 2008 in a clustered environment
• Skills in coordinating activities, active listening, and monitoring performance
• Skills in complex problem solving, judgment, critical/analytical thinking, logic/reasoning, and decision making
• Skills in analysis and maintenance planning on production systems
• Skills in data replication, and synchronization with external systems
• Ability to communicate effectively via multiple channels (verbal, written, etc) with technical and non-technical staff
• Ability to work independently & in small team environments
• Ability to be versatile and handle multiple projects and re-prioritizations
• Ability to create & implement sophisticated security models that meet business demands
• Ability in the design and implementation of back-up plans as well as disaster recovery including planning & testing
• Ability to troubleshoot and piece together conclusions and apply rules to produce answers that make sense
• Ability to work with outside vendors and individuals in a professional manner
• Ability to sit all day looking at a computer screen

Preferred Skills:

• Possession of an undergraduate degree in computer information technology, computer engineering, or related degree strongly preferred
• Minimum of 5 years experience in a technical environment with familiarity in computer hardware/software, applications, software engineering and development

Role Type: Direct Placement

Location: Indianapolis, IN

Feel free to contact me at mpeterson@theoris.com (you can attach your resume and preferred rate) or call 317-968-9844 if you’re interested in learning more details.

Senior Oracle DBA opportunity in Indy

Role Title: Senior Oracle DBA

Role Description:

• Heads down administration role (troubleshooting, tuning, production support, break/fix, etc.)
• Not too geared to the Application Development/Design side of Data Bases
• Primary responsibilities for the support of Oracle/SQL Server databases, Oracle Application servers support EBS and Integration environments
• This Includes installation, updates/patches, upgrades, tuning, optimization, backups and resource management
• Responsible for database support of Oracle EBS Application Databases and associated custom-developed conversions, interfaces, and bolt-ons
• Develop, document and maintain procedures for patch loads, data backups, restores, performance tuning, and configurations of all aspects of an Oracle RAC and Application Server technology Maintain relationship with vendors such as Oracle, Teradata, Microsoft etc.
• Administer, maintain, develop, document and implement policies and procedures toensure the security and integrity of all Oracle and some SQL Server databases
• Working and Conceptual knowledge of Enterprise Data Warehouse & OLAP tools
• Advise Application Development teams on database usage, PL/SQL best practices andapplication tuning
• Participate in 24X7X365 on-call rotation
• The on-call DBA must be able to facilitate andmanage diverse database, infrastructure and application problems and provide third levelsupport to other on-call teams
• Total project responsibilities for medium to large efforts following client project management techniques
• Complete projects on-time, on-target, on-budget
• Establish goals and measurements and track/report regular progress to Senior DBA
• Produce results and deliverables and be open to learning internal project managementtechniques
• Assist with strategic direction setting and decision making relating to technology implementation in the data center

Required Skills:

• 4-6 years as Oracle 10g/11g DBA on a RAC environment
• At least two of these years working with high demand based, service oriented environment on UNIX/Windows
• 1-2 years experience in Implementing and tuning Oracle Applications and supporting customization
• Experience with Oracle Financials
• Strong working knowledge of Database design fundamentals and the use of modeling tools for logical and physical data modeling
• Strong knowledge of SQL, PL/SQL, SQL and database instance tuning using OEM Grid Control, Backup & Recovery using RMAN- Veritas Netbackup interface and all other aspects of Database Administration
• Experience with High Availability technologies such as RAC, Dataguard, Flash Back etc.
• Strong working knowledge of Microsoft Project or other project management tools
• Working knowledge of the architecture, implementation, and support of an enterprise data warehouse
• Experience with at least one other RDBMS technology such as SQL Server and/or Teradata Bachelors Degree in Computer Science, IT or MIS Job related certifications a plus but not a requirement

Preferred Skills:

• SAN based experience preferred
• EBS R12 preferred
• Order Management and Retail specific applications is considered a plus
• ERWIN preferred
• Knowledge of Java, XML, Born Shell etc. is desirable

Education:

• Bachelors Degree in Computer Science, IT or MIS Job related certifications a plus but not a requirement

Location: Indianapolis, IN

Role Type: Permanent Placement

Feel free to contact me at mpeterson@theoris.com (you can attach your resume and preferred rate) or call 317-968-9844 if you’re interested in learning more details.

Urgent DBA role/high chance to fill in Concord, CA!

Role Title: Database Administrator

Role Description:

• The Database Administrator is responsible for data analysis and database management
• Database Administrators typically are involved in maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning
• Database Administrators are also responsible for understanding , configuring, and managing database administration tools
• Performance tuning and troubleshooting for database
• Performs application database maintenance and provide technical assistance to the users
• Manages database account access and database object changes
• Ensures that monitoring and alerts are properly in place to meet database monitoring requirements
• Performs application database and OS scripting
• Reviews Information Protection compliance reports and notifications for individual databases and internal processes (including compliance updates and compliance set ups)
• Performs data purging and data replication activities
• Performs database recovery from logs, hot & cold backups, Export/Imports and Disaster Recovery
• Performs database creation decommissioning and database updates/migrations to a higher/lower version or cross platform migrations
• Also involved in database, schema and object refresh activities
• Monitors and reports existing database Instance, Database, Server activities for CPU, Memory, Cache, Logs performance and recommends effective resource utilization/emergency recovery procedures
• Provides Escalation Level 2 Technical 24x7 support
• Performs Business Continuity/Disaster Recovery activities during Business Continuity Plan events
• Plans, schedules, and implements operating system software installs and patches (including 3rd party tools) using change management and release management processes Education: Education and Experience equally evaluated for relevance

Required Skills:

• 5-7 years of experience (7-10 preferred)
• Oracle 10g or better (11g preferred) on HPUX or Linux platform Experience building, maintaining, and tuning large transactional databases (preferably SAP related) Oracle RMAN, Dataguard, HA concepts, advanced backup/recovery, Disaster recovery
• Advanced performance tuning (SQL, parameters, design) Database migrations (SQL to Oracle, HPUX or other Unix to Linux)
• Looking for experienced DBA to build, maintain, and tune large transactional Oracle databases supporting our SAP and Ariba ERP systems
• Must have someone with 24-hour support experience

Location: Concord, CA

Duration: 4+months (chance to extend based on client needs)

Oracle Apps DBA/Consultant Needed in Denver

Role Title: Oracle Apps DBA/Consultant

Role Description:

• The Technology Operations DBA Specialist is responsible for implementing timely, complex database technology solutions to multiple BPO customers during all phases of the capability release design, build, test and run of software
• The Technology Operations DBA Specialist maintains the integrity of the test and production environments and ensures that those changes are managed through the lifecycle
• The Technology Operations DBA Specialist executes database technology requests and serves as the ongoing escalation point for requests as necessary
• The Technology Operations DBA Specialist works with Technology Operations Analysts and Specialists to resolve problems

Key Responsibilities:

• Responsible for database administration, including table maintenance, backup and restore, database design and data integrity
• Implement standards and processes that facilitate stability of production environments
• Includes daily administration of database security and data integrity, table maintenance, database design
• Develop and maintain deep knowledge of the databases and development tools used by BPO
• Provide consultation and participation with difficult troubleshooting efforts for Architecture, Product Support and Technology Development
• Maintain databases for software testing and production environments
• Resolve complex problems related to software and database configuration
• Assists with project work and development work as well as daily maintenance tasks and provides on-call coverage
• Research and resolve Requests for Assistance (RFAs), meeting or exceeding established criteria for customer service and satisfaction
• Create and maintain communication channels with other teams, groups, and organizations. Liaise with the IO and CIO Technology Services organization
• Manage own work in executing complex technical tasks, such as database upgrades and hardware replacement, on schedule, on budget and with expected quality
• Maintain a strong understanding of the BPO products and how they are used in various technical environments
• Perform research and testing to investigate technical issues
• Update and maintain technical documentation
• Evaluate new technologies and recommend usage to achieve improved operational efficiency or improved service
• Monitor and act on production issues
• Implement improvements to production system monitoring & support procedures
• Provide deep knowledge of the data model for use by people writing reports
• Ensure that report designs return the correct data and are written to execute without introducing performance issues
• May manage of third-party hardware and software vendor relationships with specific vendors. Evaluate new and existing products from these vendors for use in BPO

Work Experience:

• 3+years of experience with multiple database systems
• Prior experience in a software development or other technical environment
• Prior experience in customer service or related role

Skill Requirements:

• Strong technical skills with and understanding of Microsoft SQL Server
• Experience with clustering and replication
• Hands-on experience with database security and SQL coding & scripting
• Technical experience with reporting tools and architectures such as Crystal Reports, OLAP Databases
• Technical experience with database utilities including performance/maintenance and backup utilities
• Demonstrated PC and UNIX skills with a strong understanding of software installation and configuration
• Specific database administration experience with Windows 2000/XP and some Unix (preferably Sun Solaris)
• Strong problem solving skills, with the ability to recognize technical deficiencies and/or opportunities, and experience developing appropriate solutions
• Good communications skills, oral and written

Location: Denver, CO

Duration: 3+months (chance to extend based on client needs)