*Please forward resumes to [email protected] <[email protected]>*
*Role: Sr. Oracle Database Administrator * *Locals to DC/VA/MD only * *Length: 12 months+ * *MUST BE LOCAL FACE TO FACE INTERVIEW REQUIRE* *The client will be doing speed interviews next Wednesday, May 18 between 1:00pm and 4:00pm. F2F is required during one of these 30 min slots. (NO SKYPE)* *ESSENTIAL DUTIES:* The position’s essential duties include the following: · Support of production and non-production databases: - Correct issues reported in production system - Support routine and ad-hoc IT DBA requests - Update documentation, if required as part of correcting production issues - Support implement SSIS packages and database objects like stored procedures, views, functions, triggers, etc. - Implement and monitor daily and nightly database maintenance jobs - Monitor, diagnose, and respond to system failure and performance issues, taking appropriate measures to reduce system downtime and eliminate recurrence of the problem - Work with USAC technical staff, including network engineers and software developers, to analyze and improve system performance - Formulate and implement backup procedures for all company databases - Serve as technical support for any database related performance or access issue · Generate ad-hoc and routine reports and define metrics for database health and performance · Administer, maintain, develop and implement policies and procedures for ensuring the security and integrity of company databases. · Leading the team in providing technical support for any database-related performance or access issue · Perform or affect the performance of all database installations, patches, and planned upgrades. · Implement data models and database designs, data access and table maintenance codes. · Resolve database performance issues, database capacity issues, replication, and other database issues; · Perform database related development as dictated by departmental or project demands. · Design and perform data migrations and data transformations as required by application delivery teams or business customers. · Develop and maintain documentation, diagrams, and procedures and complies with company’s change management control process. · Ensure that all database designs adhere to industry best practices. · Work with application delivery teams during database design. · Possess substantial knowledge about application and database performance profiles of all databases under their management. · Represent the IT department in terms of database expertise in coordination with other departments. *TECHNICAL EXPERIENCE* *Type of Experience - ORACLE Years of Experience* · Database administration with Oracle 11g/12c, ASM 7+ Years · Oracle Dataguard (preferably Active Data Guard), Grid Control, RMAN 5+ Years · Oracle Real Application Clusters (RAC) and Storage Administration 7+ Years · SQL Server Management Studio, SQL Server Integration Services 7+ Years · Database administration with SQL server 2005, 2012 R2. 7+ Years · Reviewing, writing, debugging, tuning T-SQL and PL/SQL code 5+ Years · Developing of SQL scripts for stored procedures and functions 5+ Years · Experience with physical database characteristics such as table design, relationships, data partition, efficient indexes, storage allocation, capacity planning etc. 7+ Years · Linux/Unix platforms and Linux Shell scripting 5+ Years · TOAD, Erwin 5+ Years · Display strong ability in troubleshooting complex issues 5+ Years · Experience in performance tuning and load testing of database 7+ Years · Knowledge of database security concepts 5+Years · Experience with high availability database and application architectures 3+ Years *NOTE*: In addition, please list any *desired* experience. - Oracle 11g/12c Certification - You have experience with NoSQL databases, such as Couchbase, MongoDB etc. - Demonstrated experience with Microsoft Reporting Services or other enterprise reporting tool. - Experience with clustered Oracle databases and high availability architectures. - SQLServer 2012 experience - Experience with agile software development such as SCRUM and XP - Experience with high availability database and application architectures - Experience with physical database characteristics such as table design, relationships data partition, efficient indexes, storage allocation, capacity planning etc. 5+ Years - Display strong ability in troubleshooting complex issues 5+ Years - Experience in performance tuning and load testing of database 5+ Years - Knowledge of database security concepts 5+Years *Regards* *Mahesh. G **Ranked No.3 in the Washington DC area-Washington Business Journal, 2015* *A CMMi Level 3 Company* *Driving the Business Trend* 14175 Sullyfield Circle, Suite # 400,Chantilly, VA 20151, U.S.A Phone: 703-880-4184 | Fax: 703-263-2113 Email: [email protected] || www.usmsystems.com ISO 9000 and ISO 20000 Certified Company Smart CEO Award Winner By SMART CEO Magazine, Baltimore, U.S.A; *Inc5000* *Recognized Fastest growing private company in * Office Locations: Washington D.C| Atlanta | Boston |Hyderabad | Bangalore, Indian -- You received this message because you are subscribed to the Google Groups "Oracle-Projects" 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 https://groups.google.com/group/oracle-projects. For more options, visit https://groups.google.com/d/optout.
