| Database Consultant - Harrisburg, PA at Harrisburg, Pennsylvania, USA |
| Email: [email protected] |
| From: Rasitha, Stellar IT Solutions [email protected] Reply to: [email protected] Hi, This is Rasitha from Stellar IT Solutions. I am reaching out to you on an exciting job opportunity with one of our clients. Position: PSERS- TAS1 A4 SC2 (Database Consultant (Microsoft SQL & PostgreSQL)) Location: 5 N 5th Street, Harrisburg, PA 17101. (Hybrid) Duration: 12+ Months 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 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 Regards, Rasitha Begum, Technical Recruiter, Email: [email protected] Keywords: access management information technology Pennsylvania Database Consultant - Harrisburg, PA [email protected] |
| [email protected] View all |
| Tue Jul 23 23:27:00 UTC 2024 |