Database Administration Analyst Peoplesoft

As a SQL Server Administrator, you will be responsible for various tasks related to SQL Server administration, database design, performance tuning, and documentation. Your primary responsibilities will include: - Installation, configuration, and maintenance of SQL Server instances across different versions such as 2012, 2014, 2016, 2017, 2019, and 2022. - Database creation, management, and performing backup/restore operations. - Managing users and roles within the SQL Server environment. - Troubleshooting common SQL Server issues that may arise during operations. You will also be involved in assisting with database design by optimizing database structures, creating and maintaining indexes, as well as stored procedures. Monitoring SQL Server performance, identifying bottlenecks, and implementing basic performance tuning techniques like indexing and query optimization will be part of your regular duties. Additionally, you will be required to maintain up-to-date documentation of SQL Server environments and procedures to ensure operational transparency and continuity. To excel in this role, you should possess a strong understanding of SQL Server fundamentals including T-SQL, database objects, and data types. Experience with database backup and restore procedures, basic troubleshooting skills for SQL Server issues, and familiarity with high availability concepts such as mirroring and failover clusters are essential. You should be able to work both independently and collaboratively within a team environment. Furthermore, having knowledge of SQL Server security best practices, data encryption, access control, and vulnerability management will be advantageous. Inventory management skills for tracking and managing SQL Server instances, databases, and other assets, as well as familiarity with SQL Server patching procedures and best practices, will also be beneficial for this role.,