*Job Title* SQL DBA / Production DBA
*Project Location* Hoboken, NJ *Duration* 6 months /Contract *Skills Required and Job Description:* *Interview Mode:: Telephonic Followed by Face to FAce* We are seeking an experienced DBA / Production DBA to join our Hoboken, NJ based Infrastructure and Operations Group. Working as part of a dedicated DBA operations team and reporting to an operations manager you will be responsible for the support of a production environment of approx 35 database servers in a busy enterprise environment on a 24/7 rotation. Qualifications and Education Requirements : Perform database backups and other DBMS maintenance jobs. : Maintain a recorded log of these scheduled jobs : Ability to execute database scripts (ddl /dml) as part of planned deployments. : Perform database restores in support of development testing efforts. : Identify performance issues and escalate to Operations manager/ GC Database engineering. : Recover and restart failed jobs as directed by Operations manager. : Provide weekend coverage on a rotation in support of project implementations. : Record database / file system growth trends to assist with capacity planning. : Use monitoring tools (Grid Control / Microsoft MOM) to identify database issues. : Strong communication skills required for this role. Experience with MS SQL SERVER 2005/2008 : Familiarity with DDL DML syntax, reading T-SQL, stored procedures. : Execute Microsoft SQL profiler in support of performance tuning efforts. : Monitoring, stopping and starting replication services as required. : SQL 2008 Cluster management, switchover and service mgmt on a cluster node. : Apply Microsoft SQL Server patches as needed to address operational issues. : Work with Microsoft support to log incidents and escalate issues to Operations manager, GC Engineering and GC Database Engineering team. Experience with Oracle 10g / 11GR2 : Familiarity with DDL DML syntax, and reading PLSQL, stored procedures. : Schedule DBMS jobs, restart failed jobs, and execute queries and data fixes. : Leverage tools such as sqltrace, TKprof, AWR, ADDM, OEM to identify performance issues. : Familiar with Unix shell scripting, awk, bash skills needed to restart database maintenance tasks. : Fluent database backup skills specifically RMAN (required) Data pump, import and export. : Perform database cloning into non production environments. : Familiar with Oracle Data guard and Golden Gate services a plus. : Implement/test disaster recovery solutions, database upgrades and exploitation of new DBMS features. DESIRED CHARACTERISTICS: Excellent interpersonal and communication skills Strong analytical skills and detail oriented Ability to multitask Excellent problem solving skills Proficient in Microsoft Office applications (Word, Excel, PowerPoint) Local candidate preferred Stable career history Previous Insurance / Re-Insurance Experience -- You received this message because you are subscribed to the Google Groups "SAP-UK" 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/sap-uk. For more options, visit https://groups.google.com/d/optout.
