*Hi ,*
*Please lookup the below position and if you are comfortable then share
your updated resume.*
*Position: Senior Database Applications Developer*
*Location: Houston, TX*
*Duration: 12 Months Contract*
*Interview Mode : Phone followed by Skype/In person Interview *
The Senior Database Applications Developer is responsible for working on
assigned projects and technical initiatives in an efficient/effective
manner. The Senior Database Applications Developer must possess a high
degree of technical knowledge regarding software development and associated
technology tools primarily using Oracle PL/SQL and SQL Server T-SQL.
The individual is expected to be able to code as necessary, perform
detailed analysis on data structures, data integration, and existing and
new applications systems.
*Essential Functions/Principal Accountabilities:*
- Provide application development, enhancements, modifications,
performance tuning and support services for assigned projects.
- Work with IS technical resources to provide high availability
monitoring and maintenance for assigned applications.
- Understand a given software project "end-to-end" specifically
beginning with Business Requirements, then the appropriate Data
Architecture and corresponding User Interface (UI), and culminating with
finished information products such as Web Viewers, Reports, Data Entry
Applications, Interfaces to Other Systems, Graphical Outputs or Data Marts.
- Prepare technical specifications for new applications, enhancements,
modifications, and support issues. Also, prepare application documentation
as required.
- Work with business analysts in requirements gathering. Develop and
support data models and a data dictionary that supports the business
requirements for tactical and strategic information products.
*Job Requirements:*
· 5-10 years’ experience in both Oracle (or) SQL Server backend
database development utilizing packages, procedures, function, triggers and
user defined types.
· 2+ years of experience in data warehousing.
· Strong Data Warehousing experience, partitioning, collection
objects.
· Strong Oracle PL/SQL (or) SQL Server T-SQL skills (strong
knowledge of Oracle 10g/11g/12c and SQL Server 2012/2016).
· Strong database query performance tuning skills (SQL tuning).
· Strong knowledge of common database tools (PL/SQL Developer,
TOAD, SQLPlus, SQL Server Management Studio).
· Strong ability to use Python scripting for data transfer and
manipulation.
· Familiarity with Oracle RAC preferred.
· Familiarity with VPD (Virtual Private Database) is a plus.
· *Proficient in working with: Collection objects, Nested Tables,
Record types, Cursors, Ref Cursors, Views, Materialized Views, Partitions,
FORALL, Bulk Collect, Regular Expressions, Triggers, Instead Of Triggers,
Autonomous Transactions*.
· Ability to build ER Diagrams for new tables.
· Ability to write complex stored procedures/triggers, functions
using PL/SQL to optimize processes performance with the goal to reduce
processing time.
· Ability to tune complex queries utilizing Indexes, Hints, and
Explain Plan to improve the performance of the application.
· Ability to design and maintain data extraction & transformation
processes (ETL).
· Working knowledge with XML, JSON preferred.
· Familiarity with NoSQL database (eg. MongoDB) is a plus.
· Familiarity with Agile methodology is a plus.
· Should possess excellent written and oral communication skills.
· Should have data analysis skills to debug, trace and fix problems.
· Bachelor’s degree required.
· Degree in Management Information Systems or Computer Science
preferred.
· Oil and Gas Industry experience preferred.
· Required to be on-call during work and off-hours as necessary.
· May travel when necessary for system implementation and training.
*Skill Matrix:*
Total IT Experience:
Experience in Oracle Backend Database Development:
Or
Experience in SQL Server Backend Database Development:
Experience with packages, procedures, function, triggers, etc (for both
oracle and sql server():
Experience in data warehousing:
Experience with Oracle PL/SQL:
Or
Experience with T-SQL:
Experience with ETL Processes:
Performance tuning of PL/SQL:
Or
Performance tuning of T-SQL:
Experience with ER Diagrams:
Highest qualification:
Certification- If Any:
LinkedIn ID- If Any:
2 Professional references:
*Thanks & Regards,*
*Abhishek Kumar | **Sr. Technical Recruiter*
*Sage Group Technologies Inc., **www.sagegroupinc.com*
<http://www.sagegroupinc.com/>
*Direct: 732.837.2134 | Email: **abku...@sagetl.com*
*W:* 732.860.4602 X 305
3400 Highway 35, Suite # 9A, Hazlet, NJ 07730
[image: Description: cid:image002.jpg@01D3AA60.A9AB3B30]
*Disclaimer*: This is not a Spam mail, we are contacting you because either
you have applied for a similar role with our company in the past, have your
resume posted on job boards, professional groups, etc., We apologize if
this email has caused any inconvenience, please disregard if this is not
relevant to you or reply with remove and we will be sure to take the
necessary steps to avoid any further inconvenience.
--
You received this message because you are subscribed to the Google Groups
"project managment" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to project-managment+unsubscr...@googlegroups.com.
To post to this group, send email to project-managment@googlegroups.com.
Visit this group at https://groups.google.com/group/project-managment.
For more options, visit https://groups.google.com/d/optout.
