Hi
Greetings from AAA Consulting Services Inc * Role: Sybase DBA * Number of Positions -- 1 * Location: Minneapolis, MN * Start: ASAP. * Duration: 6 Months * Rate: Open. * Face-to-Face: May be required. If you cannot cover the cost of f2f in your rate quote above let us know on submission and we'll talk about options. * Work Authorization -- Open. DESCRIPTION: Client is seeking a Sybase DBA to come in and assist their existing DBA group for ~ 6 months. Production environment is very model centric so background in similar setups is ideal. In addition, candidates with strength in both DB modeling and working with application development teams has been key in the past. ROLE DETAILS: ----- Collaborates with application development team(s) in the analysis of applications requirements, design and construction processes ----- Creates and maintains physical data models that meet the business and systems requirements ----- Constructs and supports transactional, operational, and informational data stores in the development and testing environment. Manages changes to the application data model and generates DDL from the model. ----- Scripts changes into package to be promoted though the environment stack. ----- Develops and maintains stored procedures, database triggers, packages, and functions as required by the application design. ----- Manages users* accounts and roles in the development and testing environment. ----- Assists development teams with achieving optimal application performance. ----- Partners with developers and data analysts to develop test data for unit testing ----- Copies or moves data from one database to another as required ----- Partners with Operations DBA in applying database patches and upgrades to application databases, including coordination of testing, data conversion, and migrations as required ----- Complies with the established company-wide database standards, best practices, SOPs and the governing directives of the Enterprise Data Architect. SKILLS SPECIFICALLY REQUIRED: * Sybase DBA. (5 years preferred) * DB Modeling Tools - Overall * DB Modeling Tools - PowerDesigner * Development. (3 years). * Data Modeling of OLTP and/or OLAP systems using ERD and/or UML modeling techniques * SQL, Transact SQL, PL/SQL development and debugging * Shell scripting. * Writing build/maintenance scripts that allow databases and their corresponding objects to be created/modified in different environments * Monitoring and optimizing system performance using index tuning, disk optimization, and other methods * Making tuning recommendations to developers related to T-SQL or PL/SQL * Working in a multi-tier architecture in client/server environment * Diagnosing and troubleshooting application and database issues * Ability to operate in unstructured environment (assess, establish plan of action, execute) NICE TO HAVE: * Oracle DBA (5 years) Best Regards, Dheeraj Kumar Technical Recruiter | AAA Consulting Services Inc 35312, Pennington Dr, Farmington Hills, MI - 48335 Email: [email protected] Direct: 248-579-0794 Web: www.aaacsi.com ASPIRE, ACHIEVE, AMAZE. -- You received this message because you are subscribed to the Google Groups "KNOW.IT" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/know_it_az?hl=en.
