Business Intelligence Database AdministrationAssist with the monitoring, maintenance and operational support of SQL BI environment and deployments and toolsets and system databases and configurations.Maintain reliability, stability and data integrity of the SQL BI environments and services. Provide support in the administration, backup, integrity and security of the database environment and SQL BI deployments and services and toolsets.Assist with various tasks from software… Show more Business Intelligence Database AdministrationAssist with the monitoring, maintenance and operational support of SQL BI environment and deployments and toolsets and system databases and configurations.Maintain reliability, stability and data integrity of the SQL BI environments and services. Provide support in the administration, backup, integrity and security of the database environment and SQL BI deployments and services and toolsets.Assist with various tasks from software upgrades and custom interfaces, to troubleshooting and monitoring. Show less

job roles and responsibilities• Install and maintain the performance of database servers.• Responsible for the monitoring and uptime of all production databases.• Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage.• Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime.• Develop Stored Procedures and Database Triggers in support of application… Show more job roles and responsibilities• Install and maintain the performance of database servers.• Responsible for the monitoring and uptime of all production databases.• Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage.• Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime.• Develop Stored Procedures and Database Triggers in support of application development.• Participate in application development projects and be responsible for the database architecture and design.• Participate in the creation of development, staging, and production database instances, and the migration from one environment to another.• Recommend and implement emerging database technologies.• Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release.• Responsible for regular backups and recovery of databases.• Responsible for regular maintenance on databases (e.g., Vacuum, Reindexing, Archiving).• Responsible for pro-active remediation of database operational problems.• Create and manage database reports, visualizations, and dashboards (e.g., Logs, PGBadger, etc).• Responsible for Query tuning and preventative maintenance.• Support complex web-based applications.• Create automation for repeating database tasks.• Perform other duties as assigned.• Be available for on-call support as needed. Show less

The database administrator (DBA) is responsible for the performance, integrity and security of the database. My primary role is to Maintain databases by identifying and solving database requirements and supporting users. I am also involved in the planning and development of the database, as well as troubleshooting any issues on behalf of the users.