Summary of this rolesql server 2019 or later ddl, dml and development of sql code performance tuning sql code indexes purging of data memory disk management knowledge of partitioned views backups, restores, integrity checks and index maintenance mirroring ssis packages (etl process) sql server upgrades database encryption at rest work change requests to update stored procedure code unit test sql changes performs testing of database software, utilities and patches within a test environment prior to production roll out.
identifies and resolves issues while in the test environment.
performs the migration of tested/approved software, utilities, and patches to the production environment.
develops basic to moderately complex database configurations by creating database objects per specified business requirements and the necessary test environments.
works in close liaison with application developers to ensure best practices are applied to mitigate potential impacts to the various user groups and/or other database configurations. Completes authentication and authorization requests by creating/purging/maintaining user accounts, adding/deleting/modifying table and data permissions.
performs and/or sets up a scheduled database audit procedure to track the who/when changes are made or new items are created.
take appropriate corrective actions based on audit results. Schedules database back-up tasks and ensures proper completion of scheduled tasks.
executes database recovery tasks during a disaster recovery and/or disaster recovery exercises. Monitors current usage levels of database storage to identify and report growth trends and assists in the forecasting of future storage requirements.
assists with the development of long-term capacity plans.
performs routine maintenance such as data compression, defragmentation, dropping temp tables, clearing transaction logs, archiving inactive databases, load balancing and evaluating server hardware to provide recommendations for performance improvements. Actively monitors database performance to identify bottlenecks, such as inefficient queries, inconsistent and/or corrupt indexes, database design, and provides recommendations for corrective actions.
performs database statistic reporting on a regularly scheduled basis.
ensures the high availability of the supported database(s). Works closely with the applications team while performing troubleshooting to determine the source of application failures.
assists in the development of solutions to minimize the potential of future application failures.
supports the implementation of solutions. Produces and maintains operational database documentation, such as sql disaster recovery, sql recovery presentation, naming standards, performance and tuning, to ensure database configurations are well documented in preparation for disaster recovery. Knowledge of cloud database platforms: google cloudsql, aws rds, azure sql.
knowledge of other database platforms mysql, snowflake and mongodb.
#j-18808-ljbffr