| Hybrid (Mostly Remote) - Database Consultant - Harrisburg, PA at Harrisburg, Pennsylvania, USA |
| Email: [email protected] |
| From: Usha Geethari, StellarIT Solutions [email protected] Reply to: [email protected] Hi, This is Usha form Stellar IT Solutions! You intrigued us in your profile; hence I have a Great Opportunity for you with our direct client so kindly view the below job description and let me know your interest to proceed further. Job Description Location: Harrisburg, PA 17101. (Hybrid) Position: PSERS- TAS1 A4 SC2 (Database Consultant (Microsoft SQL & PostgreSQL)) Duration: 12+ Months Maximum Pay: $50/hr on c2c Complete Description: Onboarding will require an 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: Database Consultant (Microsoft SQL & PostgreSQL) 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. Skill Required / Desired Amount of Experience Consultants Experience Minimum of 5 years of experience in database administration, development, and architecture. Required 5 Years Proven experience with Microsoft SQL Server and PostgreSQL. Required Strong knowledge of SQL Server and PostgreSQL database architecture, configuration, and administration. Required Experience with database backup and recovery solutions. Required Familiarity with data modeling and data warehousing concepts. Required Knowledge of scripting languages (e.g., Python, Bash) and automation tools. Required Experience with cloud-based database solutions (e.g., AWS RDS, Azure SQL Database). Required Excellent problem-solving and analytical skills. Required Strong communication and collaboration abilities. Required Experience with cloud-based database solutions (e.g., AWS RDS, Azure SQL Database). Required Thanks & Regards, Usha R Senior Talent Acquisition https://www.linkedin.com/in/usha-g-3a2ba2101 Work: 240-774-0203| Email: [email protected] Rockville, MD | McLean, VA | Palo Alto, CA StellarIT.com | StellariDeaLabs.com Keywords: rlang information technology California Maryland Pennsylvania Virginia Hybrid (Mostly Remote) - Database Consultant - Harrisburg, PA [email protected] |
| [email protected] View all |
| Tue Jul 23 22:14:00 UTC 2024 |