SQL servers administration.

Team lead activities.

SQL servers administration

Lead PostgreSQL Database AdministratorMaintaining AWS RDS databases.Creating and implementing data retention policy, performance optimizations.Database upgrade project planning and implementation

Senior MSSQL Database Administrator

• Review and approval of the database design and data models produced by development teams.
• Monitor databases/Servers to optimize database performance, resource use, and physical implementations of databases.
• Address various database integration issues including migration between disparate databases, integration, maintenance & conversion, capacity planning issues, and new applications.
• Maintain development, test, and production environments.
• Monitor and manage database backups, logs, and journals.
• Restore and recover data as required.
• Install, maintain, and upgrade database servers and related software and tools.
• Monitor and maintain database security and database software.
• Controlling access permissions and privileges.
• Advises on troubleshooting, exception processing needs, and other data management issues.

MS SQL DBA

Provide technical support for the company’s production, developer, and test databases and associated technologies, including SQL Server 2008, 2012, and 2014.

Maintain security and overall reliability of all database platforms.

Install database systems, apply optimum access techniques, coordinate installation, and document actions.

Perform database monitoring, maintenance, reorganizations, resource management, schema management, capacity planning, and performance tuning for the company’s databases.

Apply patches to fix bugs and enhance functionality and security as required and in conjunction with the company’s procedures for change control.

Provide technical architecture and design as required.

Perform code promotions in compliance with the company’s procedures for change control.

Work with developers and analysts to support development efforts. Clone SQL server databases as needed to support development and testing efforts.

Work with various internal teams such as server, storage, backup & network administration teams to coordinate and troubleshoot infrastructure-related issues.

Implement and maintain backup and disaster recovery plans for critical production databases and applications.

Administrating Windows servers, Active Directory, SQL servers

Windows based system administration