*Dear,* *Hope you are doing well…..*
*Please send resumes to r...@hclglobal.com <r...@hclglobal.com>* *ROLE* *SR SQL DBA* *LOCATION* *Des Moines IA* *DURATION* *LONG TERM* *CLIENT* *DIRECT* *INTERVIEW TYPE* *In-Person * *Local candidates strongly preferred* *ALL candidates MUST be able to attend a personal interview, NO phone interviews, NO Skype, NO exceptions* *State Experience Highly Preferred* *U.S. Citizens and those authorized to work in the U.S. are encouraged to apply* *Note: For H1 While submitting I need consultant I 797 OR ID Proof.* Responsible for serving as a technical liaison for the Conservation and Recreation Division (CRD) for applications that are hosted externally by a vendor. Technical support will also include first level application support and database support. This position will work under the general direction of senior Information Technology Specialists and closely with vendor technical staff. *Will need to know how to:* Run Queries Pull Reports per requested data elements *Technical Support of vendor hosted applications: * Primary applications supported include the Electronic Licensing System of Iowa (ELSI) and the Cabins & Campground Reservation System. Support activities include: · Design, implement, and maintain analytical and reporting processes under general supervision: o Install, configure, and maintain the IBM DB2 client and Web access application on all necessary staff PCs. o Install and configure ODBC data access tools to query various application databases. o Develop, implement, and maintain query tools to ensure highest possible data integrity and accuracy. o Analyze requests and extract large and complex data sets to produce information in an understandable format for many purposes including, but not limited to: customer sales and demographics, validation of system changes, customer compliance with regulations, including assistance with multistate Law Enforcement o Undercover operations, sales of customer information to external customers, and many specialized requests by internal customers for ad hoc data. · Design, program, document, test, implement, debug, and maintain standalone MS Access databases to extract application data for single purpose specialized uses, e.g. delinquent child support license revocations, vendor financial reporting, house magazine subscriber import and transfer. · Coordinate first level application security: Fulfill requests for new users specifying system viewing/editing privileges, user access changes, and removals. Access the security system to set and reset passwords. · Provide technical support for additional vendor applications as they are acquired by the CRD. · Business Applications Technical Support: · Databases: o Design, program, document, test, debug, and implement standalone MS Access databases upon management · Approval. Some development involves data extraction, importation, and manipulation from extraneous sources. · Train staff as appropriate. Examples include: Western States Violators Compact, hiring tracking, performance · Evaluation monitoring, records sales invoicing. o Provide primary troubleshooting and maintenance support to 3rd party developed MS Access databases within o Central Office. Requirements typically involve code changes, data cleansing, additional query and report o Development. Examples include: Liquidated Damages, Miscellaneous Licenses, Recreational Dealer Licensing, o Employee Roster, Operator Certification. Responsible for identifying opportunities were databases may be converted from an MS Access databases to SQL Server. · Word Processing and Spreadsheets: o Design, develop, test, debug, and implement automated templates and reporting tools in MS Word and Excel · Throughout the department as requested and approved by management. Prepare documentation and train users as necessary. Examples include: TIP reporting, boater/hunter education certification, county recorder boat, · Snowmobile, and ATV reporting, numerous form letters. *Skills* *Required* *Years Used* *Last Used* Access Database Skills *5 Years* SQL - Ability to write and run queries to extract data *5 Years* My SQL *5 Years* DB2 *5 Years* FTP *5 Years* Pull reports per required data elements *5 Years* Thank You, Warm Regards, Mani Technical Recruiter HCL Global Systems Inc. Email: r...@hclglobal.com Web: http://www.hclglobal.com Certified Minority Business Enterprise (MBE) ___________________________________________________________________ DISCLAIMER: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the -- You received this message because you are subscribed to the Google Groups "Oracle Developers" group. To unsubscribe from this group and stop receiving emails from it, send an email to oradev+unsubscr...@googlegroups.com. To post to this group, send email to oradev@googlegroups.com. Visit this group at https://groups.google.com/group/oradev. For more options, visit https://groups.google.com/d/optout.