*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 "SAP
BASIS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sap-basis+unsubscr...@googlegroups.com.
To post to this group, send email to sap-basis@googlegroups.com.
Visit this group at https://groups.google.com/group/sap-basis.
For more options, visit https://groups.google.com/d/optout.
