Albin Engineering Services, Inc. (http://www.aesi.com) is looking for a database architect who is able and willing to work as a data modeler, database developer, and DBA for production databases. This is a contract to direct hire position for a solid Customer Service Management Software Company.
Responsibilities:
1. Short term (3 - 6 months): Candidate will be involved in re-factoring existing stored procedures and production support of hosted databases. The job requires excellent skills in T-SQL programming and performance optimization expertise specific to MSSQL 2005. The same level of expertise is required in Oracle and PL/SQL.
2. Long term: Candidate will be a senior member of data architecture team
Leverage expertise in:
- Current platforms: Oracle, SQL Server
- Future Platform: Postgres
- Mentoring:
- Educate the rest of the staff on data layer best practices
- Document best practices for on-going db maintenance
Own the data model:
- Analyze and understand the business processes and design databases for various applications that support those processes
- Develop and maintain stored procedures, triggers, views for the applications as required
- Review of requests / suggestions, with recommendations & action plans
- Business logic migration from SPs to application layer
Support priority customer issues regarding data layer:
- Respond to CPE escalation requests for confirmed S1 CRs involving data layer
- Do not respond to tech support directly
Administration Support (when requested):
- Setup, maintain and support databases and other database related tasks
- Design, optimize and monitor the databases
- Setup database clusters, and backup and recovery processes
Job Requirements:
- BS in Computer Science or related field
- Excellent skills in T-SQL programming and performance optimization expertise specific to MSSQL 2005
- 7+ years of experience as database developer on Microsoft SQL Server including SQL Server 2005, or Oracle 8i, 10g databases
- 3+ years of experience with database administration, support, optimizations and monitoring
- Experience developing and deploying Stored Procedures, Triggers, SQL Jobs, Data Imports and Transformations
- Strong hands on experience
- Strong communication and documentation skills
Please NO THIRD PARTY VENDORS.
If you are interested, please forward your resume (.rtf/.doc) to david.fletcher@aesi.com. Let him know you found this job via The SiliconValley NewTech Meetup group and reference Job Order #191135.
Loading