| App Data Architect at Phoenix, Arizona, USA |
| Email: [email protected] |
| From: Tapan Patel, Veridian tech solution [email protected] Reply to: [email protected] Job Type- App Data Architect Location : Phoenix , AZ (only local) Position Contract Update on JD :- Thanks for the profiles but it seems they have a robust experience in architecture and Data management. We are looking for a profile with the following job description who can contribute his/her 90% of the time. for the PL/SQL code development. Job description : Design, define and maintain databases. Understand Database table partitioning procedures. Create and maintain stored procedures for data transfer between apps and databases. Create complex SQL queries for different ad-hoc reporting and for integration with reporting tools. Extensively use SSIS transformations such as Lookup, Derived column, conversion, task, etc. have Hands on experience in developing and deploying SSIS and SSRS in different environment. Should have experience in data warehousing including business intelligence tools-SQL, SSIS and SSRS. Should have used T-SQL objects like Stored Procedures, Triggers, Tables, Views, Index, User Defined Functions, Data integrity, variables, cursor, CTE, joins etc. Experience in Performance tuning of Queries and indexing to improve Performance. Ensure policies for handling sensitive date (PCI, PII) ethically within the application. Should have used T-SQL objects like Stored Procedures, Triggers, Tables, Views, Index, User Defined Functions, Data integrity, variables, cursor, CTE, joins etc. Experience in Performance tuning of Queries and indexing to improve Performance. Experience on Table Partitioning, Backup and Recovery. Proficiency in creating a database from the group up for a brand-new application. Ability to design tables and organize data in a manner that maximizes performance, incorporating use of suitable indexes and partitions Keywords: active directory information technology procedural language Arizona |
| [email protected] View all |
| Thu Jan 25 19:19:00 UTC 2024 |