| Database developer ...................NEW YORK Kew Gardens, NY (This is an HYBRID position.) at York, New York, USA |
| Email: [email protected] |
| From: Balram Kumar Singh, Spear Staffing LLC [email protected] Reply to: [email protected] Role- Database developer Location- NEW YORK Kew Gardens, NY (This is an HYBRID position.) Agency: The Office of the Queens County District Attorney (QDA) Contract- C2C The Office of the Queens County District Attorney (QDA) is seeking a Level 2 Programmer with a minimum of four years of experience with writing application software, data analysis, data access, data structures, data manipulation, databases, programming, testing and implementation, technical and user documentation, and software conversions; environments including but not limited to servers, personal computers, and laptops; and assisting and/or leading in the design of program specifications and the implementation of software solutions. The Level 2 Programmer will serve as a Database Developer within QDAs Information Technology Bureau (ITB), and will help design, implement, optimize, and support relation database management systems to support in-house created and off-the-shelf commercial applications to aid in tracking and processing cases. The Database Developer will be part of QDAs Application Development Department of ITB that includes a staff of 12 and serves an office of over 850 staff. The Database Developers responsibilities will include: Design redundant, highly available database clusters for several in-house and off-the-shelf enterprise applications Implement and maintain zero loss database mirroring across multiple nodes in multiple clusters. Develop stored procedures that conform to specific outputs and performance requirements to support. Create and maintain SQL agent jobs that provide customer reporting and data maintenance. Carry out monitoring, tuning, and database performance analysis. Design and implement SQL queries, triggers, and new reports to support business needs. Utilize ad-hoc techniques to perform on-the-fly analysis of data. Design, implement and maintain ETL processes, procedures, and policies in support of business analytics and reporting. Work with data analysts on refining ETL business rules. Contribute to organizational and program goals, objectives, and development. Perform index tuning and optimization tasks using SolarWinds DPA Develop and maintain entity relationship diagrams of data stores. Integrate with our current production object-oriented, Iris, databases. Design disaster recovery plan, schedule and implement the plan on a regular basis. Create and document various data views for use in data visualization tools, such as Power BI Maintain object relationship consistency across all related data stores, enforcing foreign key constraints on dependent tables. Implement role-based security access, leveraging SSO and MFA where required. REQUIRED SKILLS/EXPERIENCE: Experience in database administration planning, design, configuration, installation, troubleshooting, integration, performance monitoring, maintenance, enhancement, and security management including: MariaDB Index Tuning E-R Diagramming Data Normalization Backup and Restore Database Mirroring Cache/Iris DB SQL Server (HA / Always On) MongoDB Comfortable with shell scripting and UNIX shell scripting. Comfortable with debugging and frameworks. Experience with ETL, SQL, SQL Server, PL/SQL, and MYSQL. Must have excellent communication skills and experience in handling confidential information Thanks and regards Balram Kumar Singh Sr Technical Recruiter Phone:- 240-261-2375 Email:- [email protected] Website:- www.spearstaffing.com This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, notify the sender immediately by return email and delete the message and any attachments from your system. Keywords: business intelligence database active directory rlang procedural language New York |
| [email protected] View all |
| Thu Aug 10 00:11:00 UTC 2023 |