Hi
Position below …………… Send me profiles : ar...@vedicsoft.com *Role : DB2 DBA- (RACF - experience needed) * *Duration : 12+ months * *Location : Lincoln, NEB* Job description : If you do have a qualified candidate I will need you and them to fill out a skills matrix that goes along with the submission. This person needs to have 7 years of experience as a DB2 DBA. Plan and Package bind process, including the effective use of the different bind options SQL and programming efficiencies used in z/OS programs (e.g. COBOL) Reviewing technical design and program SQL code for technical analysts, including the ability to use EXPLAIN or VisualExplain Grant privileges for DB2 at the System, Database, Plan, Collection, Package, Table, and Usage levels Creating and reviewing logical and physical data models, ensuring they adhere to standards Maintaining a data dictionary and conforming to data naming standards Administering and enforcing security standards, controls and procedures for data access Experience maintaining RACF group profiles in a DB2 for z/OS environment. Optim Move for DB2 (IBM) Omegamon for DB2 (IBM) File Aid for DB2 (Compuware) *DB2 DBA at State of NE* – · Maintain physical database objects in development and production environments. · Review, create and maintain logical and physical data models and ensure they adhere to application system standards. Collaborate with technical analysts to ensure proposed system enhancements conform to these standards · Maintain data naming standards · Maintain data dictionary to provide data structure and definitions with business and technical stakeholders. · Monitor system performance and pro-actively take action to maintain client service levels, including reviewing access methods, and access times. · Administer and enforce security standards, controls and procedures for data access based on business and legal requirements protecting State's information from intentional or inadvertent destruction or unauthorized access. · Review designs for cost-effective solutions and communicate alternatives to technical analysts. · Support distributed database access from multiple computing platforms including security, and performance considerations. Support for ADO/ODBC, and JDBC type connections to supported database system(s). · Mentor technical analysts; assist with modeling and/or performance assignments. Review technical design and program SQL code for technical analysts and provide constructive feedback for improved system access. · Responsible for providing audit information for data integrity and/or fraud investigations. · Responsible for ensuring backup and recovery strategies are in place and functional. · Provide Production 24x7 support for access to data stored in project database(s) (On Call rotation support will required). Best Regards, *Arjun Kanakoti * *VEDICSOFT* | *Business Intelligence. Delivered.* Tel 732.623.9900 x 2947 | mailto:ar...@vedicsoft.com <ar...@vedicsoft.com> ------------------------------------------------------------------------------ 13 years in IT. 400 employees. $40M in revenues. ------------------------------------------------------------------------------ ISO 9001 Certified in Software Development & Prof. Staffing Top 5 Best Places to Work in NJ by NJBIZ for 2010, 2011 Inc. 500/5000 Fastest 2004, 2007, 2008, 2009, 2010, 2012 NJ Finest businesses by NJBIZ for 2004, 2005, 2006, 2007, 2008 NJ Entrepreneur of the Year (Finalist) by E&Y for 2008, 2010, 2012 -- 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 oracle-projects+unsubscr...@googlegroups.com. To post to this group, send email to oracle-projects@googlegroups.com. Visit this group at http://groups.google.com/group/oracle-projects. For more options, visit https://groups.google.com/groups/opt_out.
