SQL Database Developer / DBA (closed)
Roseville, CA
$90,000-95,000 ideal conversion salary or $50-60/hour w2 compensation
Start the conversation: This is the recruiter hiring for this position. Start networking here:
Job Description
We are currently looking for a mid level Database Developer / Administrator to join our Product Development team in Roseville, CA. Leveraging your experience in database design and administration, you will be responsible for the installation, enhancement, and maintenance of large-scale (TB) Oracle and SQL Server databases running both in our product development environment and at client sites around the country.
Specific responsibilities may include the following:
- Review, commit, and maintain day-to-day database change scripts
- Enforce standards and best practices identified by the Data Architect
- Perform database backups and restores
- Perform data loads and extracts
- Assist the Configuration Manager with deployments and migrations
- Serve as a SQL language syntax technical expert
- Serve as an RBDMS platform technical expert
- Identify issues and escalate suggestions for database improvements (tables, indexes, DAL changes, etc.)
- Maintain and monitor operational DB maintenance plans.
- Troubleshoot operational DB issues (isolate problem queries or connections, capture and analyze DB traces, etc.)
- Augment the Development Team as needed with software development tasks
Limited travel to client sites may be required.
PREFERRED EXPERIENCE, SKILLS AND COMPETENCIES:
- 2+ years work experience performing Database Administrator duties on both Oracle 10g and SQL Server (2005/2008/2008R2) databases
- Experience with Data Warehouses and High Volume databases
- Experience with database modeling tools such as ER/Studio or equivalent
- Experience with Visual Studio .NET and/or Eclipse
- Experience with .NET 3.5 framework, AJAX, CSS, Web Services, and .NET-JAVA interoperability
- Experience with version control software and related principles (tagging, branching, etc.)
- Familiarity with DB2 databases
- Configuration/Build management experience, including knowledge of InstallShield
Top 3-5 must have skills:
- BS in Computer Science or related field
- 4+ years relevant work experience in a software development environment
- 2+ years work experience performing Database Administrator duties on Oracle and/or SQL Server databases
- Strong understanding of Relational Databases, Data Structures, and SQL (T-SQL and PL/SQL), in addition to the creation and application of E-R Diagrams and Data Dictionaries.
- Demonstrated proficiency in Java (J2EE) or .NET
- Demonstrated experience in the area of database/query performance tuning
- Familiarity with prevalent SDLC methodologies
Key Words: Database Developer, Oracle, SQL, Database, .NET , CSS, Java, developer, DBA, administration
Degree Requirement (if any): yes 4 year
