MSSQL DBA || Minneapolis, MN || $60 max.

[Savi Technologies LLC]

Please share suitable profiles.

Title: MSSQL DBA

Location: Minneapolis, MN

Duration:6 months

Descriptions:
"MS SQL Server Administration (Primary Focus - 70%) Installation & Configuration:
•       Install, configure, and upgrade SQL Server instances (2016/2019/2022)
•       Deploy and manage SQL Server on Windows and Linux platforms
•       Configure SQL Server on Azure (Azure SQL Database, Managed Instance, SQL VM)
•       Set up and maintain development, testing, and production environments
•       Implement SQL Server clustering and Always On Availability Groups
•       Configure database mirroring and log shipping for disaster recovery
Performance & Optimization:
•       Monitor and tune SQL Server performance using DMVs, Extended Events, Query Store
•       Analyze and optimize query execution plans
•       Implement and maintain index strategies (clustered, non-clustered, columnstore)
•       Perform database defragmentation and statistics updates
•       Configure Resource Governor for workload management
•       Optimize tempdb configuration and usage
•       Conduct capacity planning and performance baseline analysis
Backup & Recovery:
•       Design and implement comprehensive backup strategies (full, differential, transaction log)
•       Perform database restores and point-in-time recovery
•       Test disaster recovery procedures regularly
•       Implement and maintain backup compression and encryption
•       Configure and manage backup retention policies
•       Document and maintain RTO/RPO requirements
•       Automate backup verification processes
High Availability & Disaster Recovery:
•       Configure and maintain Always On Availability Groups
•       Implement and manage failover cluster instances (FCI)
•       Set up database mirroring and log shipping solutions
•       Design multi-datacenter DR strategies
•       Perform regular failover testing and documentation
•       Monitor synchronization health and latency
Automation & Scripting:
•       Develop T-SQL scripts for automation and maintenance
•       Create and manage SQL Server Agent jobs
•       Implement PowerShell scripts for administrative tasks
•       Automate database deployment and refresh processes
•       Build monitoring and alerting solutions
•       Develop self-service tools for development teams
SSIS, SSRS, SSAS Administration:
•       Deploy and manage SSIS packages and projects
•       Configure and maintain SSRS report servers
•       Support SSAS tabular and multidimensional models
•       Troubleshoot ETL processes and data integration issues
•       Optimize package execution and resource usage
Oracle Database Administration (Secondary - 20%)
•       Manage Oracle Database instances (11g/12c/19c)
•       Perform basic Oracle administration tasks (user management, tablespaces, backups)
•       Monitor Oracle database performance and health
•       Execute Oracle patching and minor upgrades
•       Support application teams with Oracle-related issues
•       Assist with Oracle to SQL Server migrations
•       Maintain Oracle backup and recovery procedures
•       Troubleshoot Oracle connectivity and performance issues
PostgreSQL Administration (Secondary - 10%)
•       Deploy and maintain PostgreSQL databases (versions 12+)
•       Configure PostgreSQL replication and high availability
•       Perform backup and recovery operations (pg_dump, pg_basebackup)
•       Monitor PostgreSQL performance and optimize queries
•       Manage user roles, permissions, and authentication
•       Support application development teams with PostgreSQL
•       Implement PostgreSQL security best practices
•       Assist with PostgreSQL to SQL Server migrations
General Database Administration:
•       Develop and maintain database standards and best practices
•       Create comprehensive technical documentation
•       Participate in 24/7 on-call rotation for production support
•       Collaborate with development teams on database design
•       Work with infrastructure teams on server provisioning
•       Plan and execute database migrations and consolidations
•       Conduct root cause analysis for database incidents
•       Provide training and mentoring to junior DBAs
•       Evaluate new database technologies and tools
•       Participate in change management and release processes"

--

Thanks

Virus-free.www.avg.com

[Savi Technologies LLC]