Database Administrator

As a Database Administrator at P Square Solutions LLC, a part of Neology Inc, you will be responsible for designing, creating, and managing efficient database tables, schemas, and relationships based on business requirements. Your role will involve ensuring that data models are scalable, secure, and optimized for performance while participating in data modeling activities to support data integrity and normalization. Your key responsibilities will include developing and maintaining complex PostgreSQL functions, stored procedures, and triggers, as well as implementing business logic within the database using SQL, PL/pgSQL, and other scripting languages. Collaboration with application developers to integrate databases into system architecture will also be a significant part of your role. You will be expected to analyze slow-running queries and optimize them to improve database performance, along with implementing indexing strategies, partitioning, and other performance enhancement techniques. Continuous monitoring, troubleshooting, and improvement of query execution times and database efficiency will be essential aspects of your work. Data management and integrity will be crucial, and you will need to ensure the accuracy and consistency of data by implementing proper data validation, referential integrity, and constraints. Additionally, performing data migrations and transformations to meet changing business requirements and maintaining updated documentation for database structures, procedures, and standards will be part of your daily tasks. To excel in this role, you should have a strong proficiency in PostgreSQL, including PL/pgSQL and SQL, and proven experience in designing and managing relational database schemas and tables. Expertise in creating efficient PostgreSQL functions, stored procedures, views, and triggers, as well as hands-on experience with database performance tuning, query optimization, and indexing, will be required. Experience working with Linux-based environments for hosting and managing PostgreSQL databases and scripting experience with Python, Bash, or other automation tools for database operations are also preferred technical skills. Knowledge of version control systems like Git and experience working within Agile development teams will be beneficial. Hands-on experience with query optimization, indexing, statistics, and familiarity with NoSQL databases like Redis, cloud-based database services such as AWS RDS, AWS Aurora, Azure Database for PostgreSQL, performance tuning tools like Toad, PEM (Postgres, enterprise manager), Redgate, and data archival and purging processes will be considered an added advantage for this role.,