| Direct client- Database Consultant (Microsoft SQL & PostgreSQL), Harrisburg, PA - LOCALS ONLY at Harrisburg, Arkansas, USA |
| Email: [email protected] |
| Direct client- Database Consultant (Microsoft SQL & PostgreSQL), Harrisburg, PA - LOCALS ONLY Onboarding will require in office (5 N 5th Street, Harrisburg, PA 17101). After onboarding for equipment, user accounts, VPN access and environment awareness. 40 hours per week hybrid (mostly remote work). Occasional in office days as directed by supervisor (typically 2-4 times/month). Interview via Teams. Job Description: Database Administration, Development, and Architecture Job Title: Job Summary We are seeking a versatile and highly skilled professional to join our team in a multifaceted role that encompasses Database Administration, Database Development, and Data Architecture. The successful candidate will be responsible for managing, designing, and optimizing our Microsoft SQL and PostgreSQL database systems. This role requires a deep understanding of database management, development, and architecture to ensure the reliability, security, and performance of our data infrastructure. Key Responsibilities Database Administration Install and configure Microsoft SQL Server and PostgreSQL database servers. Perform regular maintenance tasks such as backups, recovery, and patch management. Monitor database performance and security, using tools like SQL Server Management Studio (SSMS), pgAdmin, SolarWinds, and AWS CloudWatch. Implement and manage database security policies to ensure data integrity and compliance with data privacy regulations. Provide technical support and troubleshoot database-related issues. Database Development Design and create database schemas, tables, views, and queries for both Microsoft SQL and PostgreSQL. Optimize database objects and queries for performance and efficiency. Develop and maintain scripts for database automation tasks. Data Architecture Design the overall structure of the database to ensure scalability, security, and performance. Create data models that represent and support business processes. Develop and implement strategies for data management, including data warehousing and data integration. Ensure adherence to best practices in database design and implementation. Qualifications Experience Minimum of 5 years of experience in database administration, development, and architecture. Proven experience with Microsoft SQL Server and PostgreSQL. Technical Skills Strong knowledge of SQL Server and PostgreSQL database architecture, configuration, and administration. Proficiency in SQL and database performance tuning. Experience with database backup and recovery solutions. Familiarity with data modeling and data warehousing concepts. Knowledge of scripting languages (e.g., Python, Bash) and automation tools. Experience with cloud-based database solutions (e.g., AWS RDS, Azure SQL Database). Soft Skills Excellent problem-solving and analytical skills. Strong communication and collaboration abilities. Ability to work independently and as part of a team. Thanks and regards, Sai Kumar Machavarapu Sr IT Recruiter Desk: 614-212-6585 1103 Schrock Road, Suite # 102 Columbus, OH 43229 www.comtechglobal.com MBE & SBA 8(a) Certified Fax : 614-423-2526 Email: [email protected] Current Openings https://www.comtechglobal.com/job-openings.php Candidates and Vendors For H1b visa and EAD (GC or OPT), we will need a copy of visa, DL, passport and I-94 on day of joining. Please do NOT submit for position if you or your candidate are not willing to share these items by joining date, as we will match copies of visa information and DL submitted with originals in person. -- Keywords: information technology green card Ohio Pennsylvania Direct client- Database Consultant (Microsoft SQL & PostgreSQL), Harrisburg, PA - LOCALS ONLY [email protected] |
| [email protected] View all |
| Tue Jul 23 19:09:00 UTC 2024 |