*PLEASE SEND UPDATED RESUMES TO [email protected] <[email protected]>*
Role : SQL Database Administrator Position Location: Costa Mesa, CA Duration : 6+ Months Position Duties: • Document the company's database environment. • When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes • Monitor per-server performance and Troubleshoot SQL Server service outages as they occur, including after-hours and weekends • Configure SQL Server monitoring utilities to minimize false alarms, manage failed jobs and replications • Designing/Testing/Implementing Backup and Archive policies • Document the company's database environment • Each week, give developers a list of the top 10 most resource-intensive queries on the server and suggest ways to improve performance on each • Design indexes for existing applications, choosing when to add or remove indexes • Advise developers on the most efficient database designs (tables, data types, stored procedures, functions, etc) • Building basic ETL jobs for accepting CSV data from the carrier using SSIS • Working with SQL Analysts to assess need and design/implement Data Warehouses for subscriber information. • Ensure that new database code meets company standards for readability, reliability, and performance • Managing SQL Server Replication paths • Designing and Building out long-term SQL Server Cluster to provide fail-over capabilities. • Provides database support by coding utilities, responding to user questions, and resolving problems. Experience • On-call troubleshooting experience with at least one production SQL Server for a year. • Finding DMV queries to answer questions about server-level performance • Using free tools like sp Blitz™ to diagnose server reliability and performance issues • Tuning T-SQL queries to improve performance Qualifications • BS in CS, Engineering, or related discipline and/or • 8+ progressive years using SQL Server in a DBA/equivalent role, with at least 5+ yrs experience on SQL Server 2005/SQL Server 2008. • Strong experience in Database Administration in SQL Server ( 2005 and 2008 ) • Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc. • Ability to detect and troubleshoot SQL Server related CPU,memory,I/O, disk space and other resource contention. • Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication. • Expert experience in implementing operational automation. • SQL Development -- ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints ) • Solid acquaintance with windows server, security delegation, SPNs, storage components. • Good communication and documentation skills. • Data Warehouse experience in Dimensional and Transactional Modeling, Materialized Views, Partitioning, SQL, and Cube Queries a must. • Experience with mission critical, 24/7 production environments required. • Strong analytical and problem solving skills. • Solid project management skills, able to multitask and very detail oriented. . • Team-player, flexible and able to work in a fast-paced environment. • Strong data warehouse/data mart/data mining experience a plus Thanks & Regards, *Chris Raj * *Technical Recruiter* *First Soft Solutions* Princeton, New Jersey, 08540 Phone: 732.325.1353| Fax: 866.569.6621 Email: [email protected] www.firstsoftsolutions.net IBM Partners |Microsoft Partners Sun |Oracle Identity Management Implementer& Solutions provider -- You received this message because you are subscribed to the Google Groups "SRAOSS REKS" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sraoss-reks. For more options, visit https://groups.google.com/d/optout.
